Re: max_wal_size and wal_keep_size

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Aug 28, 2022 at 8:46 AM James Pang (chaolpan) <chaolpan@xxxxxxxxx> wrote:

Hi,

It’s PGv13,  what’s relationship between max_wal_size and wal_keep_size ?  For example, wal_keep_size=200GB(to keep enough wal on disk pg_wal) ,   what’s best value for max_wal_size ?   we want to usage max_wal_size to control checkpoint .


The settings are independent.  Do you think your checkpoints are occurring too often or not often enough?  (After an unclean shutdown does it take too long for the system to come back up again?)

Cheers,

Jeff



[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux