<[EMAIL PROTECTED]> writes:
> I have been having a bit of a play with using COPY to load a reasonably large
> table - 3 million rows ~ 57000 8K pages ("fact0" for those of you that have
> suffered these postings previously).
> I decided to compare 7.1.2 and current (7.2.dev 29/0701)sources on a number of
> different platforms.
> The results show a definite improvement for the current sources on all tested
> platforms :
Cool...
I suspect this must be due to the changes I made to avoid unnecessary
locking and lseek() overhead during insertion of successive tuples into
the same disk page. I wouldn't have guessed it'd make that much
difference for a single backend, however.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
