Re: large table

On 9/22/2014 12:33 PM, Luke Coldiron wrote:
>
> It is possible and that is part of what I am trying to discover 
> however I am very familiar with the system / code base and in this 
> case there is a single process updating the timestamp and a single 
> process reading the timestamp. There are no other user processes 
> programmed to interact with this table outside of potentially what 
> Postgres is doing.

ANY other connection to the same postgres server, even to a different 
database, that has an open long running transaction (most frequently, 
"Idle In Transaction") will block autovacuum from marking the old tuples 
as reusable.



-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast