Re: pg_xlog is getting bigger - Mailing list pgsql-general

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.klaver@gmail.com