Re: Time-Delayed Standbys

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Time-Delayed Standbys
Дата
Msg-id CA+TgmoapcHW_z6aJ_rxmf8MDxxrp+Yn6c3OTeXoEEstw7v+w8g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Time-Delayed Standbys  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Ответы Re: Time-Delayed Standbys
Re: Time-Delayed Standbys
Re: Time-Delayed Standbys
Re: Time-Delayed Standbys
Re: Time-Delayed Standbys
Список pgsql-hackers
On Tue, Dec 3, 2013 at 12:36 PM, Fabrízio de Royes Mello
<fabriziomello@gmail.com> wrote:
> On Tue, Dec 3, 2013 at 2:33 PM, Christian Kruse <christian@2ndquadrant.com>
> wrote:
>>
>> Hi Fabrizio,
>>
>> looks good to me. I did some testing on 9.2.4, 9.2.5 and HEAD. It
>> applies and compiles w/o errors or warnings. I set up a master and two
>> hot standbys replicating from the master, one with 5 minutes delay and
>> one without delay. After that I created a new database and generated
>> some test data:
>>
>> CREATE TABLE test (val INTEGER);
>> INSERT INTO test (val) (SELECT * FROM generate_series(0, 1000000));
>>
>> The non-delayed standby nearly instantly had the data replicated, the
>> delayed standby was replicated after exactly 5 minutes. I did not
>> notice any problems, errors or warnings.
>>
>
> Thanks for your review Christian...

So, I proposed this patch previously and I still think it's a good
idea, but it got voted down on the grounds that it didn't deal with
clock drift.  I view that as insufficient reason to reject the
feature, but others disagreed.  Unless some of those people have
changed their minds, I don't think this patch has much future here.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Why we are going to have to go DirectIO
Следующее
От: Noah Misch
Дата:
Сообщение: Re: pgsql: Fix a couple of bugs in MultiXactId freezing