On 12/19/2012 01:39 PM, AI Rumman wrote:
>
> Well just for grins and to go to the source, look in the
> postgresql.conf file itself.
>
> In particular what is the settings for:
>
> wal_keep_segments
>
> Also what does querying pg_stat_activity as the postgres user show?
>
> Looking for queries that have been held open a long time.
>
>
>
>
> wal_keep_segment = 0
> and in pg_stat_activity all processes are idle.
Please reply to the list also.
Well the question is how long have those idle transactions been around?
For a good blog on the subject see:
http://www.depesz.com/2008/08/28/hunting-idle-in-transactions/
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com