Josh Kupershmidt <schmiddy@gmail.com> writes:
> On Wed, May 12, 2010 at 12:58 AM, David Fetter <david@fetter.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