Re: 8.3.4 PITR recovery questions

On Fri, 2008-10-17 at 15:09 -0500, Kevin Grittner wrote:

> In both cases it seemed to take longer to apply the WAL files during
> the recovery process than we're used to from 8.2  I don't have hard
> numbers, but before I spent time investigating I thought I would ask
> here if that is already a known issue.

We're doing a lot in 8.4 to improve performance. I'm allowing bgwriter
to be active, so that cleaning and restartpoints are handled
asynchronously. Koichi is releasing a patch to use readahead on the WAL
files. Taken together we might expect recovery to be at least twice as
fast on a 2+ CPU system.

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