Re: General queston on getting rid of unused WAL files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Benjamin Krajmalnik" <kraj(at)servoyant(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: General queston on getting rid of unused WAL files
Date: 2013-01-09 02:16:40
Message-ID: 8318.1357697800@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Benjamin Krajmalnik" <kraj(at)servoyant(dot)com> writes:
> Looking at pg_xlogs, I see that postgres is sequentially reusing all of
> the available WAL files, while looking at the log file, it is recycling
> approximately 70-80 files every checkpoint, but it is not removing any
> files.

[ squint... ] It should be removing those files until it gets under
approximately 2 * checkpoint_segments WAL files. So, what have you
got checkpoint_segments set to?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2013-01-09 03:27:34 Re: General queston on getting rid of unused WAL files
Previous Message Benjamin Krajmalnik 2013-01-09 01:55:33 General queston on getting rid of unused WAL files