Re: PITR performance costs

Поиск
Список
Период
Сортировка
Искать
От
Merlin Moncure
Тема
Re: PITR performance costs
Дата
в 10:07:46
Msg-id
b42b73150705290606t29535f8bi9930d73215664964@mail.gmail.com
Ответ на
Список
Дерево обсуждения
PITR performance costs Dave Cramer <pg@fastcrypt.com>
Re: PITR performance costs Simon Riggs <simon@2ndquadrant.com>
Re: PITR performance costs Bill Moran <wmoran@collaborativefusion.com>
Re: PITR performance costs "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: PITR performance costs Heikki Linnakangas <heikki@enterprisedb.com>
Re: PITR performance costs Dave Cramer <pg@fastcrypt.com>
Re: PITR performance costs Stephen Frost <sfrost@snowman.net>
Re: PITR performance costs "Merlin Moncure" <mmoncure@gmail.com>
On 5/28/07, Dave Cramer  wrote:
> Since PITR has to enable archiving does this not increase the amount
> of disk I/O required ?

I've set up warm standbys on a few servers (some of them quite
busy!)...the additional load is virtually unmeasurable.  I usually
don't copy the files locally...I scp them off to some other server.
When archived, the WAL files are likely cached but there is some
overhead to copying them off however.

merlin
В списке pgsql-performance по дате отправления
От: PFC
Дата:
От: Merlin Moncure
Дата:
FAQ