Re: Pulling data from a constraint def - Mailing list pgsql-general

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