Re: PITR performance costs

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: PITR performance costs
Дата
Msg-id AB783D40-6095-40EB-A779-B3387EF87136@fastcrypt.com
обсуждение исходный текст
Ответ на Re: PITR performance costs  (Heikki Linnakangas <heikki@enterprisedb.com>)
Ответы Re: PITR performance costs  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-performance
Heikki,

Don't the archived logs have to be copied as well as the regular WAL
logs get recycled ?

Dave
On 28-May-07, at 12:31 PM, Heikki Linnakangas wrote:

> Dave Cramer wrote:
>> Since PITR has to enable archiving does this not increase the
>> amount of disk I/O required ?
>
> There's no difference in normal DML operations, but some bulk
> operations like CREATE INDEX that don't otherwise generate WAL,
> need to be WAL logged when archiving is enabled.
>
> --
>   Heikki Linnakangas
>   EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: PITR performance costs
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: PITR performance costs