Re: "Hot standby"? - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: "Hot standby"?
Date
Msg-id 4A81850C02000025000298BA@gw.wicourts.gov
Whole thread Raw
In response to Re: "Hot standby"?  (Mark Mielke <mark@mark.mielke.cc>)
Responses Re: "Hot standby"?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Mark Mielke <mark@mark.mielke.cc> wrote:
> This patch does not provide streaming replication?
There's a separate effort to provide asynchronous and synchronous
streaming replication.  Different patch.
> "Hot standby" to me means "the slave is as close to up-to-date as
> possible and can potentially take over at any time in a near
> instance." This *implies* some sort of streaming replication (byte
> level rather than file-by-file) rather than waiting for WAL logs to
> become full and shipped.
Most of use would expect that from something called "hot standby".
That's why so many of us have been saying that the name is misleading.
This patch, as I understand it, would allow you to use the warm
standby to run read-only queries -- for reports and such, to take some
load off the primary database.  No more; no less.
So it's still warm, not hot, and it's still usable as a warm standby.
It just lets you squeeze a little extra benefit from the copy while it
sits there periodically updating itself.
-Kevin


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: "Hot standby"?
Next
From: Tom Lane
Date:
Subject: Re: Re: pgindent timing (was Re: [COMMITTERS] pgsql: Refactor NUM_cache_remove calls in error report path to a PG_TRY)