"Jeremy Haile" <[EMAIL PROTECTED]> writes:
> 1) Why does the performance degrade as the table sizes grow? Shouldn't
> the insert performance remain fairly constant if there are no indexes or
> constraints?
Yeah, insert really should be a constant-time operation if there's no
add-on operations l
I am importing roughly 15 million rows in one batch transaction. I am
currently doing this through batch inserts of around 500 at a time,
although I am looking at ways to do this via multiple (one-per-table)
copy commands for performance reasons.
I am currently running: PostgreSQL 8.0.4, Redhat
