Re: Growing pg_xlog

Florian Weimer <fw@deneb.enyo.de> writes:
> I seem to have some obscure problem with the WAL logs (AFAIK that's what
> is stored in the pg_xlog directory):

> 63G     /var/lib/postgres/data/pg_xlog

> This is a bit too much wasted space for my taste. 8-/

The only theory that comes to mind is that the automatically issued
checkpoint operations are failing before they get to the stage of
truncating the WAL.  Is there anything suspicious looking in the
postmaster log?

You could also try a manual CHECKPOINT and see if it fails.

            regards, tom lane