Re: Minimizing Recovery Time (wal replication)

From: Bryan Murphy <bmurphy1976(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Minimizing Recovery Time (wal replication)
Date: 2009-04-13 14:39:28
Message-ID: 7fd310d10904130739m2482c127r332018174fa895f8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Apr 12, 2009 at 5:52 AM, Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2009-04-13 16:04:30 Re: Can't get the debugger going
Previous Message Raymond O'Donnell 2009-04-13 14:32:36 Re: pgSql authentication problem with openLdap