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 1vIkBr-00CgIY-0U for pgsql-admin@arkaria.postgresql.org; Tue, 11 Nov 2025 08:57:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vIkBo-004zQW-0D for pgsql-admin@arkaria.postgresql.org; Tue, 11 Nov 2025 08:57:24 +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 1vIkBn-004zQN-2C for pgsql-admin@lists.postgresql.org; Tue, 11 Nov 2025 08:57:23 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vIkBl-00786S-0g for pgsql-admin@lists.postgresql.org; Tue, 11 Nov 2025 08:57:23 +0000 Received: by mail-ed1-x52d.google.com with SMTP id 4fb4d7f45d1cf-640aa1445c3so6046432a12.1 for ; Tue, 11 Nov 2025 00:57:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1762851435; x=1763456235; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=g6rjXlZ1g9dofD07QSNnpyvmlI0cndhhLRh9IKAOv0Y=; b=lvQN3ftN8/TV/oS2meNOXCq1IUjk/HEyKfdcCoxqRG2W1lXlMXqKBYJOUC1nLSGZZ9 bJjQip27//Fru6I5ijCDaE26TagO3WLHysbt4jHHD/fCN46shPsgbg4wsWjgiWwFss8e B59Vl4n33GL4N9O4CBvTwfpN234/nGPdeCVwddf7QY0a0THPJhqrBoqvUFiVRlfw/wzA Hk/6KcX6BOrzHd/w2moYqgn1RWkHMVpwk4zwy6X6Zxu4hqZ4n8Q6lELDoZl6UREmGjJK O6CBep0U2ED9F6hUzMbNnWyGNgXao3SqNYRCqD96Y239eDZlaAOQorTruOA3qL2o7KZ5 0Beg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762851435; x=1763456235; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=g6rjXlZ1g9dofD07QSNnpyvmlI0cndhhLRh9IKAOv0Y=; b=qBx9tZLRZUPItKEGymIHIjfYc5sBEoOLjbVt6nGx55AL27XSN/5OQQaYzIZ+CILTPX Df7xRtLjFi5evbKya3qzhBdMfmzKaHSV3XwSkNTxgG4F8ttXMnz5LJ3QRCbypZsJBF0B D0GBKI7MThlXRfRQ66CXfHUtV19/JSe5z7QMeQU1vHlXEUO9g1A7cE0tyTt3q/BJbxR0 7TwwC0Fucj9S5FRHCo8TTk7UbYYpGUKJGXuKyFR2UF0VD5Ha5eohAmPdzP7jkYz8VSP2 SQQzDHIFs97dhVNwkr0F0RVhSlDVWQzMrBxBsnjuDtjn+cFtnsGjMmabZWClC/ig6Pu7 5WDQ== X-Forwarded-Encrypted: i=1; AJvYcCXLiHP19D1a+aJcMVzIGJp4gNzY2DBDPWVCd/JmdtuRaFiU9NoroNTGm5DPSG4QSSZBB353lVy5mkSipQ==@lists.postgresql.org X-Gm-Message-State: AOJu0YxmpDLFVwYgRZDvPTU3c7XIWT8Fvy7LNXHJso80J83UEIoNLd0q Zaj8u4sT18wiuXlqi9FU67kPrjvPzIfucSB5u5mVGv4/rdWc3icfrQVlwdT+UUynnHk= X-Gm-Gg: ASbGncstc/9TI32vYqDxYlddg/666AT6qDR9BRvosjQbiJa5Lvnbc0zgWrvPFUyPVMZ Wd+5q3VaFONL+s+/uaH0af6vkI7nmdVGREG+FSsT6v23pRmXWFFL06zdwDvofxQCsX+1hKgDKaw AX9yWWop4aIPwiLn245P5zrsTJd4j9uniq25xomWm2u4K4bQX0F5IFMR5p2Awe0KXRWGXg/TfGY 1LOVvw94/3hVJbigvSeF9XUTKcGFpOb529BhklbEK/BOjUYA0njw9Qf2MZRbjIRf0GuPFuLBGYc nyKlRGGU3xxenpWtB/5GiCnzrFM/cCDfl+KO0gxrUuhiqyZzgnd53FDBvctIMMYEvDMpHizDFwd ZMID/tT5hjVl12eJbs55Y6psGeH8MZkXtPpZ3wt400sjBtw5FrwAi6o42fD6YBbBhy+Uj5xcvM4 3X5Sp6lTUET0gPeGlhqqDh5XwFKYE5Pro4HPF0jF61 X-Google-Smtp-Source: AGHT+IFboMiWNBre8MfG63Hp06mnJJgqyTBzFDpgm8CyOcyzi9aAY90IferqiaDs9LAd4kXUMj6Jow== X-Received: by 2002:a17:907:9807:b0:b6d:68cf:68e2 with SMTP id a640c23a62f3a-b72e05e8239mr1014811966b.65.1762851434816; Tue, 11 Nov 2025 00:57:14 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b72bf9be009sm1279657066b.60.2025.11.11.00.57.14 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 11 Nov 2025 00:57:14 -0800 (PST) Message-ID: Subject: Re: Postgres Parameters From: Laurenz Albe To: Sam Stearns , Pgsql-admin Date: Tue, 11 Nov 2025 09:57:13 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2025-11-10 at 15:28 -0800, Sam Stearns wrote: > Could someone advise on how to determine the correct settings for the fol= lowing, please?: >=20 > =C2=A0* checkpoint_timeout > =C2=A0* max_wal_size Leave "checkpoint_timeout" as it is, and increase "max_wal_size" to 10GB. Wait, and if pg_stat_checkpointer tells you that many checkpoints are *not* triggered by timeout, increase "max_wal_size". Yours, Laurenz Albe