Re: 8.3.4 PITR recovery questions

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: 8.3.4 PITR recovery questions
Дата
Msg-id 1225353580.3971.353.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на 8.3.4 PITR recovery questions  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SSL and md5 password?
Следующее
От: damien clochard
Дата:
Сообщение: Re: system catalog views + tables