On Wed, Apr 22, 2009 at 9:21 PM, Robert Haas <robertmh...@gmail.com> wrote: > Maybe I'm just dumb, but I don't get it. If I start a transaction and > do "SELECT * FROM foo" and then wait around for an hour or two while > someone else makes changes to foo and then do "SELECT * FROM foo" > again, I expect to see the same rows I saw the first time, which means > they still need to be around.
Yeah, I'm dumb. It doesn't work this way. I guess I always assumed that this was the reason why <idle in transaction> caused database bloat, but apparently not! ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
