On Wed, Apr 22, 2009 at 9:21 PM, Robert Haas <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
