Re: pg_xlog is getting bigger

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_xlog is getting bigger
Date: 2012-12-20 02:41:22
Message-ID: 50D27AD2.5080403@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/19/2012 04:54 PM, AI Rumman wrote:
>
>
> I modified checkpoint_segment to 100 form 300 and then forced some
> CHECKPOINT and pg_switch_xlog() and now found that the pg_xlog file got
> almost 1 gb of space back.

Per Toms post this is a start but probably not the answer.
Have you looked in the pg_xlog directory itself to see if anything
looks funny? One thing I could think of is file timestamps that do not
look right.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2012-12-20 03:03:22 Re: [GENERAL] trouble with pg_upgrade 9.0 -> 9.1
Previous Message Adrian Klaver 2012-12-20 02:34:20 Re: pg_xlog is getting bigger