Re: Standby server lagging behind - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Standby server lagging behind
Date
Msg-id 407d949e1001220751x2c98ab41h6c49394b6de77476@mail.gmail.com
Whole thread Raw
In response to Re: Standby server lagging behind  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Fri, Jan 22, 2010 at 2:37 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
>
> I think I have some recall of improvements to that in the 8.4
> release, so an upgrade might help.

There was a standalone program which you can call from your recovery
script to prefetch the blocks needed to replay the next log file
before starting to apply it. I find this message but there may be a
more recent version if you search:
http://archives.postgresql.org/pgsql-hackers/2008-11/msg01807.php

Otherwise I think there were some performance improvements to replay
but I don't recall which versions which improvements were in.

-- 
greg


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: plpythonu DO support (inline call handler)
Next
From: Tom Lane
Date:
Subject: Re: Access to dynamic SQL in PL/pgSQL