Re: Improved Load Speed From Current Sources

<markir@slingshot.co.nz> 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