"fkater@xxxxxxxxxxxxxx" <fkater@xxxxxxxxxxxxxx> writes: > Thank you for the interesting link. I think, though, that > this does not address the question why there is a delay > between the point in time A that client 1 has successfully > commited and the point in time B when client 2 can see all > new rows! There is no such delay. Either you forgot to commit in client 1, or client 2 had a query snapshot that was taken before client 1 committed. 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