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 1wRtAV-002mOQ-1h for pgsql-committers@arkaria.postgresql.org; Tue, 26 May 2026 14:54:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wRtAR-004e0N-3C for pgsql-committers@arkaria.postgresql.org; Tue, 26 May 2026 14:54:04 +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 1wRtAR-004e0F-2X for pgsql-committers@lists.postgresql.org; Tue, 26 May 2026 14:54:04 +0000 Received: from mail-ed1-f45.google.com ([209.85.208.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wRtAQ-00000001WzR-1qNw for pgsql-committers@lists.postgresql.org; Tue, 26 May 2026 14:54:04 +0000 Received: by mail-ed1-f45.google.com with SMTP id 4fb4d7f45d1cf-67c9616b4feso16932932a12.1 for ; Tue, 26 May 2026 07:54:01 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779807241; cv=none; d=google.com; s=arc-20240605; b=Ly3XNI2Siz6dUQ0clF/9TmUcX/SezQHQZIcCOFXlk8Kgwn8s9ttWfVlEdGdX33zu3I Yuden0ONv7GQuzcF4XRGAQO92dtOF56o6SQBGfovZvuap1YizMRXXoMyWG52SBN4CKGS rAc/yXa+tbtVpewQuEqcf3d6A7PeeHqZkJhJInCOzZGBGUlVcN25arBO5m642cQpeRKQ BR8+cR5jZ2KHod53q1LjyoL6APYdJacDiqfiNCMaGeQA9yTc3+KaoX4doXSy8MS4W8ft 3b3oT32F6RzsRJ97CkGIPrQMunfHC5cdRTOlaixbk7GboDseF4JwanWFEoL2/BY1AN+F A8Dg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version; bh=y4fUCGK/91fuIQUomylMVe2eYVnNNKMwdgklCVL7U1M=; fh=kEAQH1Xn63CVUfsRVEimDF9hyRiygcuvKzN1oKBwblI=; b=P8A+WEXC0/S44jHkf4+OnLmLoRK3aQ+UGcUUW0azbzJw4kKXnWlE1pa9noLl4HRgbN 8B1AEpdeVrQtQHD8+897Cw9OV/Cx30NuRr2Cu/PTbEPIj8AsHmtvBg3c25/vSgtExtpq Tj9dU6nYsQHolKKC5cg9couOylL/iBzbiFBD/3u4c/Lq+XNWCpVvcI2ZpmUGhppmYd6B 7wrYIlNBrLEavdIiz2l9KqpJFPF/J6eC+1S+AZLZsjH2vrT9dyAF+C2M/yus8C+nUt4f 1eRt2qGJEDVwev/QQ9egMvcuUD9zF74fEYD0qqKSNAWHZBI5dOVquZlH7Sdf+thMfWIz 7v9Q==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779807241; x=1780412041; 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=y4fUCGK/91fuIQUomylMVe2eYVnNNKMwdgklCVL7U1M=; b=jKNO9S1uXRSeiqj22RwpL6FrcW9TSlqk+xgRF2GRDFtFTIGdLnyKcXEDV8/UEi7Tsi eCd60GVkADpg22vRxg235iNY/E6Fgm7dz1zGszez64tAiwajyzAXdiuJdHtWJPCFKj38 gmKeDVC+BOdisAjIuyjBxCEZgi3YzrkXwEC+ycvUzUfDeYhI6mQeCkpUGTmI+5xbj6Jh sBEy/ZoO62GutglKpAK8XxaliyWrcxDP9mFsSW1djhYDWLjiEF3Cl51qoopYbGAJhaq6 wyTst2IslagU8Q+EKRGj49CM35YSv3PCPl/+hqfGRrcTYqdzMjr4Vq2Mu5Xjli73Clzd W5Rg== X-Gm-Message-State: AOJu0Yw3YupesURNNHaTpVh5IwnOepgHZhskN/mhoR5lWBA9q95uP7CI W+vEZ3o+se4tIYFPlHkMFdjFeiqQkoFPj3H2bm8D124t6LXMHMG0KDAtqIao/x5nV8C2HtWKAbo wBmFZV/P/edTxe+e1XEunCsEnlV+btDD2b8HXeHxz9A== X-Gm-Gg: Acq92OHLbTGp01zeWTy/i1UBktC22hzFSi74/Cb0ycNOl08Z18UL8g0GN0s52tb7GU3 Px5htafOhOm0/gi+qALIIj7B9LfpGv9AbvgUK9TGWcVyCTx73yfyJMXdm9wGgpz3PktCfwpiXUF i3dYpmKE0wbopzQbb3Zv6nIL3+2ZGv/3RlqahGsSTruYRLJMVddDIqsv4uas/zVSmCLNrh4CbFM lJPLNzGnk+gmqF6yPOmQPKhaQuuAsl8T40eB4ipNYDM6qffEzy9TCbLqa5vxd80QHitROo8X2o8 aSSfIEQ= X-Received: by 2002:a05:6402:35d1:b0:670:b72b:4044 with SMTP id 4fb4d7f45d1cf-6889c477b56mr9238161a12.15.1779807240631; Tue, 26 May 2026 07:54:00 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Thom Brown Date: Tue, 26 May 2026 15:53:34 +0100 X-Gm-Features: AVHnY4KshurPY809bW0x3GDBM_IKgMevvEPOMtutgEJfBv0Eo84y6f7dIF3idIY Message-ID: Subject: Re: pgsql: doc: Clarify CHECKPOINT handling of unlogged buffers To: Daniel Gustafsson Cc: pgsql-committers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 25 May 2026 at 11:23, Daniel Gustafsson wrote: > > doc: Clarify CHECKPOINT handling of unlogged buffers > > The CHECKPOINT reference page still described checkpoints as flushing > all data files, which could be misleading as it depends on the value > of FLUSH_UNLOGGED option. Update the description to make it clearer > that only data files of permanent relations are flushed by default. > > Author: Chao Li > Reviewed-by: Daniel Gustafsson > Discussion: https://postgr.es/m/4855807D-F1CA-44E6-9B58-406691832848@gmail.com > > Branch > ------ > master > > Details > ------- > https://git.postgresql.org/pg/commitdiff/377cc45194f4f1bd6eb68bd6eb42402e46e326d7 > > Modified Files > -------------- > doc/src/sgml/ref/checkpoint.sgml | 6 ++++-- > 1 file changed, 4 insertions(+), 2 deletions(-) "All data for permanent relations files will be flushed to disk, dirty buffers of unlogged relations are not flushed unless FLUSH_UNLOGGED is specified." This doesn't quite read right. "permanent relations files" should be "permanent relation files" and the sentence looks like it should end after "flushed to disk", with "Dirty buffers" being the start of a new sentence. Regards Thom