Josh Kupershmidt <[email protected]> writes:
> On Wed, May 12, 2010 at 12:58 AM, David Fetter <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
