Josh Kupershmidt <schmiddy@xxxxxxxxx> writes: > On Wed, May 12, 2010 at 12:58 AM, David Fetter <david@xxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
