| From: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Pulling data from a constraint def |
| Date: | 2010-05-13 03:22:11 |
| Message-ID: | AANLkTikiPzi2O3uwesdC5Lvtrd0Pj-7aaFSDdvLVkgNO@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, May 12, 2010 at 12:58 AM, David Fetter <david(at)fetter(dot)org> wrote:
> If you've measured a performance issue for a table that tiny, it's a
> bug that needs fixing in PostgreSQL. What measurements have you done
> so far?
Just for fun, I tried it out myself. Here are the times I got on my
modest laptop:
CHECK constraint:
* 500k INSERTs: 3.8 seconds
* 500k UPDATEs: 6.0 seconds
Foreign Key:
* 500k INSERTs: 18.7 seconds
* 500k UPDATEs: 21.2 seconds
Test SQL is attached.
Josh
| Attachment | Content-Type | Size |
|---|---|---|
| check_vs_fkey.sql | text/x-sql | 1.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2010-05-13 04:24:47 | Retiring from the PostgreSQL core team |
| Previous Message | Craig Ringer | 2010-05-13 02:52:56 | Re: Server tries to connect without ssl support |