Re: When is newly inserted data visible to another connection?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>
Cc: Yeb Havinga <yebhavinga(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: When is newly inserted data visible to another connection?
Date: 2010-08-18 13:43:28
Message-ID: 18724.1282139008@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Derrick Rice 2010-08-18 13:48:50 Warm Standby and resetting the primary as a standby
Previous Message Igor Neyman 2010-08-18 13:35:27 Re: Windows 2003 server installation issue