From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | hlinnaka(at)iki(dot)fi, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: remove pg_standby? |
Date: | 2015-03-02 23:22:00 |
Message-ID: | CAHGQGwHAOKm-ndv2U5YMhzDEmK+xt3f4_LjZa_9kqsBv1WDwyw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Mar 3, 2015 at 3:07 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>
>> Per document,
>>
>> ------------------
>> In fast failover, the server is brought up immediately. Any WAL files
>> in the archive that have not yet been applied will be ignored, and all
>> transactions in those files are lost. To trigger a fast failover,
>> create a trigger file and write the word fast into it. pg_standby can
>> also be configured to execute a fast failover automatically if no new
>> WAL file appears within a defined interval.
>> ------------------
>
> I thought we had that as a 9.4 feature, actually. Well wait ... that's
> for streaming.
s/9.4/9.3?
That's different from one we had in 9.3. Fast failover that pg_standby
supports is something like the feature that I was proposing at
http://www.postgresql.org/message-id/CAHGQGwHtvyDqKZaYWYA9zyyLEcAKiF5P0KpcpuNE_tsrGTFtQw@mail.gmail.com
that is, the feature which allows us to give up replaying remaining
WAL data for some reasons at the standby promotion. OTOH, fast
failover that was supported in 9.3 enables us to skip an end-of-recovery
checkpoint at the promotion and reduce the failover time.
Regards,
--
Fujii Masao
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2015-03-02 23:22:18 | Re: Idea: GSoC - Query Rewrite with Materialized Views |
Previous Message | Josh Berkus | 2015-03-02 23:18:16 | Patch: raise default for max_wal_segments to 1GB |