Re: LISTEN considered dangerous

On Wed, Aug 02, 2006 at 09:15:46AM -0400, Oisin Glynn wrote:
> I was just about to say that if someone was to do the following they
> would get the previously commited state of foo after the sleep not how
> foo looked before the sleep otherwise every begin would need an entire
> DB snapshot to be taken? Seems like it should be no different.  I have
> been following this thread as I use LISTEN but not in as intensive way
> as the op and for me its working fine...
>
> BEGIN
> select sleep(100000);
> select * from foo;

Well, it depends on the transaction mode, read-committed and
serialisable behave differently here. In the case of serializable, you
will get what was before the sleep(), that's kind of the point.

The whole point of MVCC is that taking a snapshot doesn't actually cost
anything.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.