Re: max_wal_size and wal_keep_size

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: "James Pang (chaolpan)" <chaolpan(at)cisco(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-28 14:52:54
Message-ID: CAMkU=1xcS0LDvvThkkSgpNwT8XvJ5TV0V0_v+b_4fMugcf+y8g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Aug 28, 2022 at 8:46 AM James Pang (chaolpan) <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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Madhu Sudan 2022-08-29 10:10:34 WAL restore is very slow
Previous Message James Pang (chaolpan) 2022-08-28 12:45:44 max_wal_size and wal_keep_size