| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | "Huda Booley (huda(at)careerjunction(dot)co(dot)za)" <Huda(at)careerjunction(dot)co(dot)za>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "simon(at)2ndQuadrant(dot)com" <simon(at)2ndquadrant(dot)com> |
| Subject: | Re: Standby server lagging behind |
| Date: | 2010-01-22 15:51:49 |
| Message-ID: | 407d949e1001220751x2c98ab41h6c49394b6de77476@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Jan 22, 2010 at 2:37 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-01-22 15:56:03 | Re: Access to dynamic SQL in PL/pgSQL |
| Previous Message | Peter Eisentraut | 2010-01-22 15:46:49 | Re: plpythonu DO support (inline call handler) |