Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL segments pile up during standalone mode - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: WAL segments pile up during standalone mode
Date
Msg-id AANLkTi=Ce79nCkBO0-7CD6ftGB0f0shMBX6vvcz+DqbE@mail.gmail.com
Whole thread Raw
In response to WAL segments pile up during standalone mode  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: WAL segments pile up during standalone mode
List pgsql-hackers
Tree view 
On Thu, Mar 3, 2011 at 3:22 AM, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> I noticed that in standalone mode, WAL segments don't seem to be
> recycled.  This could get problematic if you're forced to vacuum large
> tables in that mode and space for WAL is short.

Checkpoint is required to recycle old WAL segments. Can checkpoint
be executed in standalone mode? even during VACUUM FULL?

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

pgsql-hackers by date:

Previous
From: daveg
Date:
Subject: Re: Re: [ADMIN] PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum
Next
From: Fujii Masao
Date:
Subject: Re: Sync Rep v17