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
Test SQL is attached.
Josh