Re: Minimizing Recovery Time (wal replication) - Mailing list pgsql-general

From Bryan Murphy
Subject Re: Minimizing Recovery Time (wal replication)
Date
Msg-id 7fd310d10904130739m2482c127r332018174fa895f8@mail.gmail.com
Whole thread Raw
In response to Re: Minimizing Recovery Time (wal replication)  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Minimizing Recovery Time (wal replication)
List pgsql-general
On Sun, Apr 12, 2009 at 5:52 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> The database is performing too frequent restartpoints.
>
> This has been optimised in PostgreSQL 8.4 by the addition of the
> bgwriter running during recovery. This will mean that your hot spare
> will not pause while waiting for restartpoint to complete, so will be
> significantly faster.

8.4 is already looking like it's going to be a great upgrade for us,
this would be another win.

Thanks,
Bryan

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: pgSql authentication problem with openLdap
Next
From: Raymond O'Donnell
Date:
Subject: Re: Can't get the debugger going