Re: [HACKERS] Avoiding shutdown checkpoint at failover

2012-08-22 Thread Fujii Masao
On Fri, Aug 17, 2012 at 8:38 AM, Bruce Momjian wrote: > On Thu, Mar 8, 2012 at 08:20:02AM -0500, Robert Haas wrote: >> On Sat, Jan 28, 2012 at 8:57 AM, Simon Riggs wrote: >> > On Thu, Jan 26, 2012 at 5:27 AM, Fujii Masao wrote: >> > >> >> One thing I would like to ask is that why you think walr

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2012-08-16 Thread Bruce Momjian
On Thu, Mar 8, 2012 at 08:20:02AM -0500, Robert Haas wrote: > On Sat, Jan 28, 2012 at 8:57 AM, Simon Riggs wrote: > > On Thu, Jan 26, 2012 at 5:27 AM, Fujii Masao wrote: > > > >> One thing I would like to ask is that why you think walreceiver is more > >> appropriate for writing XLOG_END_OF_RECO

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2012-03-09 Thread Robert Haas
On Fri, Mar 9, 2012 at 3:00 PM, Simon Riggs wrote: > On Thu, Mar 8, 2012 at 1:20 PM, Robert Haas wrote: > >> Are we still considering trying to do this for 9.2?  Seems it's been >> over a month without a new patch, and it's not entirely clear that we >> know what the design should be. > > It's im

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2012-03-09 Thread Simon Riggs
On Thu, Mar 8, 2012 at 1:20 PM, Robert Haas wrote: > Are we still considering trying to do this for 9.2?  Seems it's been > over a month without a new patch, and it's not entirely clear that we > know what the design should be. It's important, but not ready. --  Simon Riggs   h

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2012-03-08 Thread Robert Haas
On Sat, Jan 28, 2012 at 8:57 AM, Simon Riggs wrote: > On Thu, Jan 26, 2012 at 5:27 AM, Fujii Masao wrote: > >> One thing I would like to ask is that why you think walreceiver is more >> appropriate for writing XLOG_END_OF_RECOVERY record than startup >> process. I was thinking the opposite, becau

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2012-01-28 Thread Simon Riggs
On Thu, Jan 26, 2012 at 5:27 AM, Fujii Masao wrote: > One thing I would like to ask is that why you think walreceiver is more > appropriate for writing XLOG_END_OF_RECOVERY record than startup > process. I was thinking the opposite, because if we do so, we might be > able to skip the end-of-recov

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2012-01-25 Thread Fujii Masao
On Fri, Jan 20, 2012 at 12:33 AM, Simon Riggs wrote: > On Wed, Jan 18, 2012 at 7:15 AM, Fujii Masao wrote: >> On Sun, Nov 13, 2011 at 5:13 PM, Simon Riggs wrote: >>> On Tue, Nov 1, 2011 at 12:11 PM, Simon Riggs wrote: >>> When I say skip the shutdown checkpoint, I mean remove it from the >

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2012-01-19 Thread Simon Riggs
On Wed, Jan 18, 2012 at 7:15 AM, Fujii Masao wrote: > On Sun, Nov 13, 2011 at 5:13 PM, Simon Riggs wrote: >> On Tue, Nov 1, 2011 at 12:11 PM, Simon Riggs wrote: >> >>> When I say skip the shutdown checkpoint, I mean remove it from the >>> critical path of required actions at the end of recovery.

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2012-01-17 Thread Fujii Masao
On Sun, Nov 13, 2011 at 5:13 PM, Simon Riggs wrote: > On Tue, Nov 1, 2011 at 12:11 PM, Simon Riggs wrote: > >> When I say skip the shutdown checkpoint, I mean remove it from the >> critical path of required actions at the end of recovery. We can still >> have a normal checkpoint kicked off at tha

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2011-11-28 Thread Greg Smith
On 11/13/2011 12:13 AM, Simon Riggs wrote: On Tue, Nov 1, 2011 at 12:11 PM, Simon Riggs wrote: When I say skip the shutdown checkpoint, I mean remove it from the critical path of required actions at the end of recovery. We can still have a normal checkpoint kicked off at that time, but that no

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2011-11-13 Thread Simon Riggs
On Tue, Nov 1, 2011 at 12:11 PM, Simon Riggs wrote: > When I say skip the shutdown checkpoint, I mean remove it from the > critical path of required actions at the end of recovery. We can still > have a normal checkpoint kicked off at that time, but that no longer > needs to be on the critical pa

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2011-11-01 Thread Simon Riggs
On Tue, Nov 1, 2011 at 1:48 PM, Tom Lane wrote: > Simon Riggs writes: >> The reason we run a shutdown checkpoint is to prevent needing to >> re-enter recovery if we crash after promotion. > > That's *a* reason, it's not necessarily the only reason.  This proposal > worries me, especially your bli

Re: [HACKERS] Avoiding shutdown checkpoint at failover

2011-11-01 Thread Tom Lane
Simon Riggs writes: > The reason we run a shutdown checkpoint is to prevent needing to > re-enter recovery if we crash after promotion. That's *a* reason, it's not necessarily the only reason. This proposal worries me, especially your blithe dismissal of the timeline issues; but in any case I wo

[HACKERS] Avoiding shutdown checkpoint at failover

2011-11-01 Thread Simon Riggs
When a server fails, we need to promote a standby as quickly as possible. Currently when we promote a standby to a primary we need to run a shutdown checkpoint before users can begin write transactions, which in many cases can take minutes. The reason we run a shutdown checkpoint is to prevent ne