| 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 23:52:19 |
| Message-ID: | 50D25333.3040007@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/19/2012 02:00 PM, AI Rumman wrote:
>
>
> 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/
> <http://www.depesz.com/2008/08/28/hunting-idle-in-transactions/>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com <mailto:adrian(dot)klaver(at)gmail(dot)com>
>
>
> Thanks for the link. But there is no connection showing 'Idle in
> Transaction'.
> All are showing only '<IDLE>'.
Hmm, got ahead of myself.
Does pg_locks show anything interesting?
Please hit Reply All so the rest of the list can stay in the loop. More
eyes = faster solution:)
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2012-12-20 00:02:50 | Re: pg_xlog is getting bigger |
| Previous Message | Kevin Grittner | 2012-12-19 22:06:44 | Re: Moving a database to a new TABLESPACE in Postgres 8.3 |