John R Pierce <pierce(at)hogranch(dot)com> writes:
> I've been using this...
> to detect old stale transactions and other long running operations
> in 8.4, there's a different high water mark I should be using instead?
No, the point of my comment was just that IDLE-in-transaction isn't as
dangerous as it used to be, from the perspective of whether VACUUM can
reclaim dead rows. There are still lots of other reasons to not want
transactions sitting open without need. They might be holding locks
regards, tom lane
In response to
pgsql-jdbc by date
|Next:||From: Andreas Brandl||Date: 2009-12-12 23:43:21|
|Subject: keeping Connection alive|
|Previous:||From: John R Pierce||Date: 2009-12-11 21:24:17|
|Subject: Re: Connection.setReadOnly()|