Richard Broersma wrote:
So, the index is not actually updated until commit? Hmmmm, that seems unlikely.It looks like the check isn't preformed until COMMIT.
--Mladen Gogala Sr. Oracle DBA
1500 Broadway New York, NY 10036 (212) 329-5251http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions
-- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance