Re: PITR performance costs

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: PITR performance costs
Дата
Msg-id b42b73150705290606t29535f8bi9930d73215664964@mail.gmail.com
обсуждение исходный текст
Ответ на PITR performance costs  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-performance
On 5/28/07, Dave Cramer <pg@fastcrypt.com> 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
Дата:
Сообщение: Re: Feature suggestion : FAST CLUSTER
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: general PG network slowness (possible cure) (repost)