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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
