pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: James Pang (chaolpan) <chaolpan@cisco.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: max_wal_size and wal_keep_size
Date: Sun, 28 Aug 2022 12:45:44 +0000
Message-ID: <PH0PR11MB5191D04014D2F4F2FD2506BAD6779@PH0PR11MB5191.namprd11.prod.outlook.com> (raw)

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 .

Thanks,

James

view thread (4+ messages)  latest in thread

Message-ID: <PH0PR11MB5191D04014D2F4F2FD2506BAD6779@PH0PR11MB5191.namprd11.prod.outlook.com>
Permalink:  ../PH0PR11MB5191D04014D2F4F2FD2506BAD6779@PH0PR11MB5191.namprd11.prod.outlook.com/
Also on:    postgresql.org/message-id/PH0PR11MB5191D04014D2F4F2FD2506BAD6779@PH0PR11MB5191.namprd11.prod.outlook.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: chaolpan@cisco.com, pgsql-admin@lists.postgresql.org
  Subject: Re: max_wal_size and wal_keep_size
  In-Reply-To: <PH0PR11MB5191D04014D2F4F2FD2506BAD6779@PH0PR11MB5191.namprd11.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox