Re: max_wal_size and wal_keep_size - Mailing list pgsql-admin

From Jeff Janes
Subject Re: max_wal_size and wal_keep_size
Date
Msg-id CAMkU=1xcS0LDvvThkkSgpNwT8XvJ5TV0V0_v+b_4fMugcf+y8g@mail.gmail.com
Whole thread Raw
In response to max_wal_size and wal_keep_size  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Responses RE: max_wal_size and wal_keep_size  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
List pgsql-admin
On Sun, Aug 28, 2022 at 8:46 AM James Pang (chaolpan) <chaolpan@cisco.com> 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


pgsql-admin by date:

Previous
From: "James Pang (chaolpan)"
Date:
Subject: max_wal_size and wal_keep_size
Next
From: Madhu Sudan
Date:
Subject: WAL restore is very slow