On 25/05/2013 20:37, Moshe Jacobson wrote: > I just created a new partition in a log table, and then built a check > constraint on the recorded timestamp column. > > I have an index on this column, but the adding of the check constraint > took a very, very long time. > > It seems that PostgreSQL 9.1 does not check the index when building a > check constraint on an indexed column. Is this correct? Is this > addressed in future releases?
At a guess, I'd imagine that the check constraint has to be checked against every row in the table, so the index would not be used anyway. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
