Re: How to get rid of superfluous WAL segments?

From: Vik Fearing <vik(dot)fearing(at)dalibo(dot)com>
To: Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get rid of superfluous WAL segments?
Date: 2014-02-06 08:27:00
Message-ID: 52F34754.6040404@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/06/2014 06:51 AM, Torsten Förtsch wrote:
> On 06/02/14 06:46, Torsten Förtsch wrote:
>> we decreased wal_keep_segments quite a lot. What is the supposed way to
>> get rid of the now superfluous files in pg_xlog?
> Nothing special. The database did it for me.

It cleans up after a checkpoint. If you've got a slow server and don't
want to wait for checkpoint_timeout (default 5 minutes), you can issue a
CHECKPOINT command yourself.

Under no circumstances should you ever delete files from pg_xlog by hand.

--
Vik

In response to

Browse pgsql-general by date

  From Date Subject
Next Message alexandros_e 2014-02-06 08:35:45 Re: Temporary table already exists
Previous Message Vik Fearing 2014-02-06 08:23:03 Re: Ordering Results by a Supplied Order