From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Latches, signals, and waiting |
Date: | 2010-09-15 14:14:23 |
Message-ID: | 4C90D4BF.3020304@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
On 15/09/10 16:55, Tom Lane wrote:
> So I'm wondering if we couldn't eliminate the five-second sleep
> requirement here too. It's problematic anyhow, since somebody looking
> for energy efficiency will still feel it's too short, while somebody
> concerned about fast failover will feel it's too long.
Yep.
> Could the
> standby triggering protocol be modified so that it involves sending a
> signal, not just creating a file?
Seems reasonable, at least if we still provide an option for more
frequent polling and no need to send signal.
> (One issue is that it's not clear what that'd translate to on Windows.)
pg_ctl failover ? At the moment, the location of the trigger file is
configurable, but if we accept a constant location like
"$PGDATA/failover" pg_ctl could do the whole thing, create the file and
send signal. pg_ctl on Window already knows how to send the "signal" via
the named pipe signal emulation.
Fujii-san suggested that we might have a user-defined function for
triggering failover as well. That's also handy, but it's not a
replacement because it only works in hot standby mode.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2010-09-15 14:35:30 | Re: pgsql: Use a latch to make startup process wake up and replay |
Previous Message | Heikki Linnakangas | 2010-09-15 13:59:21 | Re: pgsql: Use a latch to make startup process wake up and replay |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2010-09-15 14:35:30 | Re: pgsql: Use a latch to make startup process wake up and replay |
Previous Message | Heikki Linnakangas | 2010-09-15 13:59:21 | Re: pgsql: Use a latch to make startup process wake up and replay |