public inbox for [email protected]  

help / color / mirror / Atom feed
From: Fabrice Chapuis <[email protected]>
To: Sam Stearns <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Postgres Parameters
Date: Tue, 11 Nov 2025 12:19:45 +0100
Message-ID: <CAA5-nLBPuxwQdZ0mFNMTP9kyQ+b9qY9PYKKWf=Q+SRxJS1iiKg@mail.gmail.com> (raw)
In-Reply-To: <CAN6TVj=QOuZDGdZegGN1ac0GPM7DgoYMBAWOJHLM68KprMAW1Q@mail.gmail.com>
References: <CAN6TVj=QOuZDGdZegGN1ac0GPM7DgoYMBAWOJHLM68KprMAW1Q@mail.gmail.com>

Hi,

You could also use this query, if the ratio is low, that means there is no
pressure on wal size and you can keep the max_wal_size value as it is.

SELECT
  num_timed,
  num_requested,
  round((num_requested::numeric / NULLIF(num_timed + num_requested, 0)) *
100, 2)
    AS requested_pct
FROM pg_stat_checkpointer;
+-----------+---------------+---------------+
| num_timed | num_requested | requested_pct |
+-----------+---------------+---------------+
|      3502 |           146 |          4.00 |
+-----------+---------------+---------------+
(1 row)

Regards,

Fabrice


On Tue, Nov 11, 2025 at 12:28 AM Sam Stearns <[email protected]> wrote:

> Howdy,
>
> Could someone advise on how to determine the correct settings for the
> following, please?:
>
>
>    - checkpoint_timeout
>    - max_wal_size
>
>
> Thank you,
>
> Sam
>
> --
>
> Samuel Stearns
> Team Lead - Database
> c: 971 762 6879 | o: 971 762 6879 | DAT.com
>
> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link;
>
>


view thread (7+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Postgres Parameters
  In-Reply-To: <CAA5-nLBPuxwQdZ0mFNMTP9kyQ+b9qY9PYKKWf=Q+SRxJS1iiKg@mail.gmail.com>

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

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