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@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
