Re: master in standby mode croaks - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: master in standby mode croaks
Date
Msg-id h2x3f0b79eb1004190231y7d5f639t3522d29758699ae7@mail.gmail.com
Whole thread Raw
In response to Re: master in standby mode croaks  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: master in standby mode croaks
List pgsql-hackers
On Mon, Apr 19, 2010 at 11:04 AM, Robert Haas <robertmhaas@gmail.com> wrote:
>> First of all, I wonder why the latter two need to affect the decision of
>> whether additional information is written to WAL for HS. How about just
>> removing XLogIsNeeded() condition from XLogStandbyInfoActive()?
>
> Bad idea, I think.  If XLogIsNeeded() is returning false and
> XLogStandbyInfoActive() is returning true, the resulting WAL will
> still be unusable for HS, at least AIUI.

Probably No. Such a WAL will be usable for HS unless an unlogged
operation (e.g., CLUSTER, CREATE TABLE AS SELECT, etc) happens.
I think that the occurrence of an unlogged operation rather than
XLogIsNeeded() itself must be checked in the standby, it's already
been being checked. So just removing XLogIsNeeded() condition makes
sense to me.

Regards,

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


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: CTAS not honoring NOT NULL, DEFAULT modifiers
Next
From: Fujii Masao
Date:
Subject: Re: walreceiver is uninterruptible on win32