Re: CHECK vs REFERENCES - Mailing list pgsql-performance

From Vivek Khera
Subject Re: CHECK vs REFERENCES
Date
Msg-id 4CF7BD03-26BB-4883-9DCA-F7CB39100BC2@khera.org
Whole thread Raw
In response to CHECK vs REFERENCES  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-performance
On Sep 9, 2005, at 11:23 PM, Marc G. Fournier wrote:

> The case is where I just want to check that a value being inserted
> is one of a few possible values, with that list of values rarely
> (if ever) changing, so havng a 'flexible list' REFERENCED seems
> relatively overkill ...
>

That's what I thought until the first time that list needed to be
altered.  At this point, it becomes a royal pain.

point to take: do it right the first time, or you have to do it over,
and over, and over...

Vivek Khera, Ph.D.
+1-301-869-4449 x806



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Deadlock Issue with PostgreSQL
Next
From: Vivek Khera
Date:
Subject: Re: Performance considerations for very heavy INSERT traffic