Re: HS/SR and smart shutdown - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: HS/SR and smart shutdown
Date
Msg-id 3f0b79eb1001290528k2b890fe2k42525e58a2486d3b@mail.gmail.com
Whole thread Raw
In response to Re: HS/SR and smart shutdown  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: HS/SR and smart shutdown  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Thu, Jan 21, 2010 at 4:27 PM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> It's a good question if that still makes sense with Hot Standby. Perhaps
> we should redefine smart shutdown in standby mode to shut down as soon
> as all read-only connections have died.

Okay. Let's work out the details.

I guess that the startup process and the walreceiver should wait
for all read only backends to exit in smart shutdown case. It's
because those backends might be waiting for the record that conflicts
with their queries to be replayed. Is this OK? Or we should kill the
startup process and the walreceiver on ahead?

If my guess is right, we would need to add new PMState to cancel
recovery and replication after all read only connections have died.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: WARNING: pgstat wait timeout
Next
From: Tim Bunce
Date:
Subject: Add on_perl_init and proper destruction to plperl UPDATE v3 [PATCH]