On Wed, Apr 22, 2009 at 9:21 PM, Robert Haas <robertmhaas@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