| From: | Raphael Bauduin <raphael(dot)bauduin(at)be(dot)easynet(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Raphael Bauduin <raphael(at)be(dot)easynet(dot)net>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: performance "tests" |
| Date: | 2002-04-11 13:42:56 |
| Message-ID: | 20020411134256.GA28547@raphael |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> If you're going to run tests on foreign-key performance, please use
> 7.2.*.
I just installed 7.2.1. I run 7.1.3 in parallel. after I run the script
to introduce 1000 rows in T1 in each version, deleting is much faster
with 7.1.3 than with 7.2.1 (I took the same configuration parameters for
both servers...). When running the delete query in parallel, 7.1.3
finishes really faster.
For inserts, the 7.2.1 is slightly faster for the first 3000 inserts,
from inserts from 3000 to 5000 it's more or less equivalent
I'll go further in documentation to look if I forgot something, but if
you have any hints, they're welcome :-)
Raph
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-04-11 14:34:40 | Re: performance "tests" |
| Previous Message | Juan Pablo Grassi | 2002-04-11 12:39:25 | Problems with PostgreSQL |