From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: WAL segments pile up during standalone mode |
Date: | 2011-03-03 14:18:38 |
Message-ID: | AANLkTim9Q9o2ZNeEmWaR04NA8=bw40sxPqUd7TFxVP+X@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Mar 3, 2011 at 9:15 AM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
> Excerpts from Fujii Masao's message of mié mar 02 22:44:45 -0300 2011:
>> On Thu, Mar 3, 2011 at 3:22 AM, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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?
>
> Hmm, I guess it would violate POLA that the standalone server would
> decide to run checkpoint in the middle of vacuum. I imagine that in
> some cases the only option would be to process the tables manually, with
> the ALTER TABLE/SET TYPE trick or similar (VACUUM FULL in 9.0+).
>
> So I can see that there is no good fix for this problem, yet it is a
> very inconvenient situation to be in.
I don't think it would violate the POLA for a standalone backend to
checkpoint periodically, but I have to admit I can count the number of
times I've run a standalone backend on one hand. Does this come up
much?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-03-03 14:38:39 | Re: Quick Extensions Question |
Previous Message | Nikhil Sontakke | 2011-03-03 14:16:04 | Re: pg_depend dependency and concurrent DDL issues in PG 8.3.x |