Re: Controlling hot standby

On Fri, 2009-01-23 at 10:35 -0600, Kevin Grittner wrote:
> >>> Alvaro Herrera <alvherre@commandprompt.com> wrote: 
> > Simon Riggs wrote:
> >> 
> >> It is on by default. Why would you want it "off" by default? 
> > 
> > Would it slow down the normal recovery after a crash if I don't have
> > any slaves?
>  
> And how about during "traditional" PITR recovery?

It is possible that it might slow down a traditional PITR recovery. But
we enable the bgwriter to do checkpoints if we have it enabled, which
were a major cause of slow down during PITR anyway.

There are considerable benefits to having it turned on during PITR

Please read this to see why
http://wiki.postgresql.org/wiki/Hot_Standby#Dynamic_Control_of_Recovery

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support