RE: A few new options for CHECKPOINT

Поиск
Список
Период
Сортировка
От tsunakawa.takay@fujitsu.com
Тема RE: A few new options for CHECKPOINT
Дата
Msg-id TYAPR01MB2990BF4A6EA75E2356DDF35DFEFA0@TYAPR01MB2990.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: A few new options for CHECKPOINT  ("Bossart, Nathan" <bossartn@amazon.com>)
Ответы Re: A few new options for CHECKPOINT
Список pgsql-hackers
From: Bossart, Nathan <bossartn@amazon.com>
> It may be useful for backups taken with the "consistent snapshot"
> approach.  As noted in the documentation [0], running CHECKPOINT
> before taking the snapshot can reduce recovery time.  However, users
> might wish to avoid the IO spike caused by an immediate checkpoint.
> 
> [0] https://www.postgresql.org/docs/devel/backup-file.html

Ah, understood.  I agree that the slow or spread manual checkpoint is good to have.


Regards
Takayuki Tsunakawa


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Libpq support to connect to standby server as priority
Следующее
От: Ashwin Agrawal
Дата:
Сообщение: Re: [PoC] Non-volatile WAL buffer