On Tue, Mar 1, 2011 at 9:19 AM, Simon Riggs <si...@2ndquadrant.com> wrote: > On Mon, 2011-02-28 at 18:40 +0000, Simon Riggs wrote: >> > SyncRepReleaseWaiters should be called when walsender exits. Otherwise, >> > if the standby crashes while a transaction is waiting for replication, >> > it waits infinitely. >> >> Will think on this. > > The behaviour seems correct to me: > > If allow_standalone_primary = off then you wish to wait forever (at your > request...)
No, I've never wished wait-forever option for now. I'd like to make the primary work alone when there is no connected standby, for high-availability. > If allow_standalone_primary = on then we sit and wait until we hit > client timeout, which occurs even after last standby has gone. In that case, why do backends need to wait until the timeout occurs? We can make those backends resume their transaction as soon as the last standby has gone. No? Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
