Re: remove pg_standby? - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: remove pg_standby?
Date
Msg-id CAHGQGwHAOKm-ndv2U5YMhzDEmK+xt3f4_LjZa_9kqsBv1WDwyw@mail.gmail.com
Whole thread Raw
In response to Re: remove pg_standby?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: remove pg_standby?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Tue, Mar 3, 2015 at 3:07 AM, Josh Berkus <josh@agliodbs.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



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Patch: raise default for max_wal_segments to 1GB
Next
From: Jim Nasby
Date:
Subject: Re: Idea: GSoC - Query Rewrite with Materialized Views