| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
| Cc: | David Fetter <david(at)fetter(dot)org>, "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 04:33:08 |
| Message-ID: | 10271.1273725188@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Josh Kupershmidt <schmiddy(at)gmail(dot)com> writes:
> 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
I'm surprised no one has yet suggested an ENUM type.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Takahiro Itagaki | 2010-05-13 05:23:48 | Re: Re: [ANNOUNCE] Bug-fix and new feature of pg_lesslog is released |
| Previous Message | Jan Wieck | 2010-05-13 04:24:47 | Retiring from the PostgreSQL core team |