Re: Postgres Parameters
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 по дате отправления: