Re: Time-Delayed Standbys - Mailing list pgsql-hackers

From KONDO Mitsumasa
Subject Re: Time-Delayed Standbys
Date
Msg-id 52A807F5.4020203@lab.ntt.co.jp
Whole thread Raw
In response to Re: Time-Delayed Standbys  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Time-Delayed Standbys
List pgsql-hackers
(2013/12/10 18:38), Andres Freund wrote:
> "master PITR"? What's that? All PITR is based on recovery.conf and thus
> not really a "master"?
"master PITR" is PITR with "standby_mode = off". It's just recovery from 
basebackup. They have difference between "master PITR" and "standby" that the 
former will be independent timelineID, but the latter is same timeline ID taht 
following the master sever. In the first place, purposes are different.

> Why should we prohibit using this feature in PITR? I don't see any
> advantage in doing so. If somebody doesn't want the delay, they
> shouldn't set it in the configuration file. End of story.
Unfortunately, there are a lot of stupid in the world... I think you have these 
clients, too.

> There's not really a that meaningful distinction between PITR and
> replication using archive_command. Especially when using
> *pause_after.
It is meaningless in "master PITR". It will be master which has new timelineID at 
unexpected timing.

> I think this feature will be used in a lot of scenarios in
> which PITR is currently used.
We have to judge which is better, we get something potential or to protect stupid.
And we had better to wait author's comment...

Regards,
--
Mitsumasa KONDO
NTT Open Source Software Center



pgsql-hackers by date:

Previous
From: KONDO Mitsumasa
Date:
Subject: Re: Optimize kernel readahead using buffer access strategy
Next
From: Simon Riggs
Date:
Subject: Re: ANALYZE sampling is too good