RE: A few new options for CHECKPOINT - Mailing list pgsql-hackers

From tsunakawa.takay@fujitsu.com
Subject RE: A few new options for CHECKPOINT
Date
Msg-id TYAPR01MB2990BF4A6EA75E2356DDF35DFEFA0@TYAPR01MB2990.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: A few new options for CHECKPOINT  ("Bossart, Nathan" <bossartn@amazon.com>)
Responses Re: A few new options for CHECKPOINT  (Michael Paquier <michael@paquier.xyz>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Libpq support to connect to standby server as priority
Next
From: Ashwin Agrawal
Date:
Subject: Re: [PoC] Non-volatile WAL buffer