Request a Demo
Home   >   mailing lists

Re: Postgres Parameters - Mailing list pgsql-admin

From Fabrice Chapuis
Subject Re: Postgres Parameters
Date
Msg-id CAA5-nLBPuxwQdZ0mFNMTP9kyQ+b9qY9PYKKWf=Q+SRxJS1iiKg@mail.gmail.com
Whole thread Raw
In response to Postgres Parameters  (Sam Stearns <sam.stearns@dat.com>)
Responses Re: Postgres Parameters
List pgsql-admin
Tree view
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 <sam.stearns@dat.com> 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


pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Postgres Parameters
Next
From: Sam Stearns
Date:
Subject: Re: Postgres Parameters