From: | "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | RE: max_wal_size and wal_keep_size |
Date: | 2022-08-30 08:29:17 |
Message-ID: | PH0PR11MB5191C07FD18F7363DD973D9ED6799@PH0PR11MB5191.namprd11.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
We want keep more wal to give more room for data replication, in case of some delay , and need old wal data. So wan to set wal_keep_size , and want to increase max_wal-size a lot to make max_wal_size > wal_keep_size (it may > 1TB).
James
From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Sent: Sunday, August 28, 2022 10:53 PM
To: James Pang (chaolpan) <chaolpan(at)cisco(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: max_wal_size and wal_keep_size
On Sun, Aug 28, 2022 at 8:46 AM James Pang (chaolpan) <chaolpan(at)cisco(dot)com<mailto:chaolpan(at)cisco(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | John Scalia | 2022-08-30 15:21:26 | Two PostgreSQL instances returning different output for same query |
Previous Message | Jeff Janes | 2022-08-29 20:38:08 | Re: WAL restore is very slow |