Re: pg_xlog Concern

From: Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net>
To: Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_xlog Concern
Date: 2015-05-18 14:00:28
Message-ID: 5559F07C.2010101@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 18/05/15 13:44, Sachin Srivastava wrote:
> But currently my pg_xlog size is 60 GB and there are 3740 WAL file in
> this folder and in Last week this was 400 GB(pg_xlog folder) and WAL
> file were approx. 30000. Due to archiving pg_xlog folder size is
> decreasing now but it’s taking one week to come in normal size.

Any chance you have unfinished transactions running for a week?

pg_stat_activity should be able to tell you that.

Torsten

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message François Battail 2015-05-18 14:07:34 Optimizing a read-only database
Previous Message Michael Paquier 2015-05-18 11:48:22 Re: