| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | markir(at)slingshot(dot)co(dot)nz |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Improved Load Speed From Current Sources |
| Date: | 2001-08-06 05:32:01 |
| Message-ID: | 17741.997075921@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<markir(at)slingshot(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ben-Nes Michael | 2001-08-06 07:37:17 | Re: VACUUM ANALYZE - with debug |
| Previous Message | markir | 2001-08-06 04:38:07 | Improved Load Speed From Current Sources |