Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vIqF8-00GWJk-0n for pgsql-admin@arkaria.postgresql.org; Tue, 11 Nov 2025 15:25:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vIqF6-006gwl-07 for pgsql-admin@arkaria.postgresql.org; Tue, 11 Nov 2025 15:25:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vIqF5-006gwd-1y for pgsql-admin@lists.postgresql.org; Tue, 11 Nov 2025 15:25:11 +0000 Received: from mx0b-0039f802.pphosted.com ([205.220.176.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vIqF2-007B2a-1a for pgsql-admin@lists.postgresql.org; Tue, 11 Nov 2025 15:25:10 +0000 Received: from pps.filterd (m0209982.ppops.net [127.0.0.1]) by mx0b-0039f802.pphosted.com (8.18.1.11/8.18.1.11) with ESMTP id 5ABEO5kj1528526 for ; Tue, 11 Nov 2025 07:25:05 -0800 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dat.com; h=cc :content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to; s=ppdk230404; bh=lC6xnNQ0uDrsdHIJMsJL5IT wMJ2kQbt3YwaqFTwwNMI=; b=Us/QdiRAv6rOGA2BDdgbcaBdlwj8qH4jtQvrMXl xubcfJUGGrmBLHdc0vttP2swXiU/arxznXNQ6+tsoUmckCH7SCYO3NFy6Bxf6HYq DXhqdClI7o5+AjJbPGgdUFSEOntNBZalOD0rNjIcyz95NV/mWCiax77uizJQAEjy D5hxpnNLakZBK/2oT0sLnNOWp51Yinbj7LXYZy0D8eKQUuMNH/jm9KEOPW8Ux6HD SC4YS3TobMR6ILZL8nDQVvJjhQ+BLsWjWRtGt9d3FVzFg9XmLaP060ls+uNtIpzI OALD17umiesysOJAzMJOLZwt3F6u18v4TQd76oYUKlZxlVw== Received: from mail-ej1-f71.google.com (mail-ej1-f71.google.com [209.85.218.71]) by mx0b-0039f802.pphosted.com (PPS) with ESMTPS id 4aaabm3ded-1 (version=TLSv1.3 cipher=TLS_AES_128_GCM_SHA256 bits=128 verify=NOT) for ; Tue, 11 Nov 2025 07:25:05 -0800 (PST) Received: by mail-ej1-f71.google.com with SMTP id a640c23a62f3a-b70be4f20deso384103866b.2 for ; Tue, 11 Nov 2025 07:25:04 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762874702; x=1763479502; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=lC6xnNQ0uDrsdHIJMsJL5ITwMJ2kQbt3YwaqFTwwNMI=; b=ds3WOcbkDSPXvhW3I3fp+C0ePjmC2gxlR2SaXFpcPNyB06/Fcvvu3NW+4syYKDtFDu 6idDKy0VChGJu03JUIZdLZRPdx2TTsw+lzv3chE7HuFLZOLOHSzfq1r1MY5hVp/9UVbz zVBdoz9B3YmAdn4AwqFYu2nhQ7ui2XqpfkaUDaJqQTH3BAwjn++EHaDwv7t9serKnVRo TC9noaKVYN4F78lNt0duUbZbmW83sp3MR24PIlcPJ0Y2RaBootrAaxs8fZkk2dQo46Ns HO/ZjrIZCRt1veUjLhka4qLKXpenmXSqpgBc59fJcm8LmMWVOzdpSl7AKzv6MA81Rlld Wglg== X-Gm-Message-State: AOJu0YzPnMHRvz/93EGe2Q1Vg0rmGmciGEDCkGUqhnTXdhnT01U+iLqt yZDBzbYNdhPMhtBK/morUc8tWUaPfKExwd1hs9hAmuKNGAW+9wsYjsNKO031tMhq2H50eyVNQJs /Ehb15Xb9yO+RLfWFxQstErqlupOcQw7bjlITWitIBcPXbnpPS5seTJbkPHbmIi2C/MELe1j7s7 qFQdNRMKS7aqxCb0Lkb2K1u4ugqjF+We5KWUXV5Fa8tl04PKsBCPy4wRLOG85bVeFiG0QRC0Q= X-Gm-Gg: ASbGncvh4ZpiCIjk1vjLLiWHS7HMJB1TxEyqfQadfkdPtt5R/Mqb+cCbSOLR4KrGSti WYQxkh6RSGzqVRBmtkPNK0EgacBgjLdwajVbAhb2urdvDRabj+c661HmeViMpvBwBqeZUfoGpQL LRCy3b/u1MONtE/gjXeZegkHFGit94XBsSj0sDU2QWwEPCurV651f2cA== X-Received: by 2002:a17:907:96a6:b0:b4e:d6e3:1670 with SMTP id a640c23a62f3a-b72e028c900mr981922166b.11.1762874702051; Tue, 11 Nov 2025 07:25:02 -0800 (PST) X-Google-Smtp-Source: AGHT+IEej7ZlkPLHPyVXgtdnBE0HZNVrHUIIIrqAeuxJyVJyCblIBfbE2hL0Mou1ZTrpICw5TwbFs1ZPVeQcF/S44Nc= X-Received: by 2002:a17:907:96a6:b0:b4e:d6e3:1670 with SMTP id a640c23a62f3a-b72e028c900mr981918366b.11.1762874701398; Tue, 11 Nov 2025 07:25:01 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Sam Stearns Date: Tue, 11 Nov 2025 07:24:49 -0800 X-Gm-Features: AWmQ_bmfRmcn0CMcgpLFimM-2gimDy5KweWKbqp-oku8LNwI7FVnkf0rUV9Ro2M Message-ID: Subject: Re: Postgres Parameters To: Fabrice Chapuis , Laurenz Albe , Ron Johnson Cc: Pgsql-admin , Henry Ashu Content-Type: multipart/alternative; boundary="0000000000005c5cb30643534010" X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1121,Hydra:6.1.9,FMLib:17.12.100.49 definitions=2025-11-11_02,2025-11-11_02,2025-10-01_01 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005c5cb30643534010 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Awesome stuff. Thank you, everyone! Sam On Tue, Nov 11, 2025 at 3:19=E2=80=AFAM Fabrice Chapuis wrote: > 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, > ZjQcmQRYFpfptBannerStart > This Message Is From an Untrusted Sender > You have not previously corresponded with this sender. > > ZjQcmQRYFpfptBannerEnd > Hi, > > You could also use this query, if the ratio is low, that means there is n= o > 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=E2=80=AFAM Sam Stearns 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 >> >> >> >> >> --=20 Samuel Stearns Team Lead - Database c: 971 762 6879 | o: 971 762 6879 | DAT.com --0000000000005c5cb30643534010 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Awesome stuff.=C2=A0 Thank you, everyone!

Sam


On Tue, Nov 11, 2025 at 3:= 19=E2=80=AFAM Fabrice Chapuis <fabrice636861@gmail.com> wrote:
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:=E2=80=8A:=E2=80=8Anu= meric / NULLIF(num_timed + num_requested,
ZjQcmQRYFpfptBannerStart
This Message Is From an Untrusted Sender
You have not previously corresponded with this sender.
=C2=A0
ZjQcmQRYFpfptBannerEnd
Hi,

Y= ou could also use this query, if the ratio is low, that means there is no p= ressure on wal size and you can keep the max_wal_size value as it is.
=

SELECT
=C2=A0 num_timed,
= =C2=A0 num_requested,
=C2=A0 roun= d((num_requested::numeric / NULLIF(num_timed + num_requested, 0)) * 100, 2)=
=C2=A0 =C2=A0 AS requested_pct
FROM pg_stat_checkpointer;<= /div>
+-----------+---------------+-----------= ----+
| num_timed | num_requested= | requested_pct |
+-----------+-= --------------+---------------+
|= =C2=A0 =C2=A0 =C2=A0 3502 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0146 |= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 4.00 |
+-----------+---------------+---------------+
(1 row)

Regards,

Fa= brice


On Tue, Nov 11, 2025 at 12:28=E2=80= =AFAM Sam Stearns <sam.stearns@dat.com> wrote:
Howdy,

Could someone advise on how to determine the correct settings for the fol= lowing, please?:

  • checkpoint_timeout
    • max_wal_size

Thank you,

=
Sam

-= -

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com


<= /span>


--

Samuel Stearns
Team Lead - Databas= e
c: 971 76= 2 6879 = | o: 97= 1 762 6879 | D= AT.com


--0000000000005c5cb30643534010--