From:
Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:
Simon Riggs <simon(at)2ndquadrant(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Yeb Havinga <yebhavinga(at)gmail(dot)com>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Sync Rep and shutdown Re: Sync Rep v19
Date:
2011-03-18 18:55:14
Message-ID:
1300474501-sup-980@alvh.no-ip.org (view raw or flat )
Thread:
2011-03-09 07:38:00 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-09 08:14:48 from Yeb Havinga <yebhavinga(at)gmail(dot)com>
2011-03-09 11:41:06 from Magnus Hagander <magnus(at)hagander(dot)net>
2011-03-09 14:10:11 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-09 14:37:00 from Yeb Havinga <yebhavinga(at)gmail(dot)com>
2011-03-09 15:03:01 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-10 04:11:07 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-16 02:07:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-16 05:43:50 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-16 11:38:44 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-16 08:51:14 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-16 11:39:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-16 17:35:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-16 22:23:37 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2011-03-17 00:30:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-17 00:53:28 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2011-03-17 06:08:51 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-17 13:33:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 17:15:25 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-18 17:25:16 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 18:55:14 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-03-18 21:19:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 22:42:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-19 14:32:53 from Yeb Havinga <yebhavinga(at)gmail(dot)com>
2011-03-20 04:44:25 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-20 15:03:04 from Yeb Havinga <yebhavinga(at)gmail(dot)com>
2011-03-21 01:05:48 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-21 16:29:38 from Yeb Havinga <yebhavinga(at)gmail(dot)com>
2011-03-21 17:04:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-21 18:51:53 from Yeb Havinga <yebhavinga(at)gmail(dot)com>
2011-03-21 22:58:15 from Yeb Havinga <yebhavinga(at)gmail(dot)com>
2011-03-22 19:25:48 from Yeb Havinga <yebhavinga(at)gmail(dot)com>
2011-03-22 19:51:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-17 12:24:43 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-03-17 13:40:44 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-17 22:00:04 from Jeff Davis <pgsql(at)j-davis(dot)com>
2011-03-18 12:27:29 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 14:17:53 from Jeff Davis <pgsql(at)j-davis(dot)com>
2011-03-18 14:27:05 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 15:38:08 from Jeff Davis <pgsql(at)j-davis(dot)com>
2011-03-18 15:58:44 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-03-18 16:37:44 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-hackers
Excerpts from Robert Haas's message of vie mar 18 14:25:16 -0300 2011:
> On Fri, Mar 18, 2011 at 1:15 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> > SyncRepUpdateSyncStandbysDefined() is added into walwriter, which means
> > waiters won't be released if we do a sighup during a fast shutdown,
> > since the walwriter gets killed as soon as that starts. I'm thinking
> > bgwriter should handle that now.
>
> Hmm. I was thinking that doing it in WAL writer would make it more
> responsive, but since this is a fairly unlikely scenario, it's
> probably not worth complicating the shutdown sequence to do it the way
> I did. I'll move it to bgwriter.
Can't they both do it?
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
Responses
pgsql-hackers by date
Next :From: Markus WannerDate: 2011-03-18 19:17:56Subject : Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous
replication.Previous :From : Dan PortsDate : 2011-03-18 18:18:32Subject : Re: SSI bug?
