| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | AI Rumman <rummandba(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_xlog is getting bigger |
| Date: | 2012-12-19 21:48:01 |
| Message-ID: | 50D23611.3060000@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert James | 2012-12-19 21:58:26 | Moving a database to a new TABLESPACE in Postgres 8.3 |
| Previous Message | Steve Crawford | 2012-12-19 21:46:48 | Re: copy from questions |