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 1w0NuS-001rRt-2N for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2026 18:03:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0NuR-00Av7n-0W for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Mar 2026 18:03:51 +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 1w0NuQ-00Av7a-2k for pgsql-hackers@lists.postgresql.org; Wed, 11 Mar 2026 18:03:51 +0000 Received: from mail-ed1-x535.google.com ([2a00:1450:4864:20::535]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w0NuO-00000002AuU-3WCy for pgsql-hackers@postgresql.org; Wed, 11 Mar 2026 18:03:51 +0000 Received: by mail-ed1-x535.google.com with SMTP id 4fb4d7f45d1cf-6611e4aefdcso127718a12.3 for ; Wed, 11 Mar 2026 11:03:49 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773252228; cv=none; d=google.com; s=arc-20240605; b=YEiE8HcAQzSs7MPJhR9xOhApwsHh9gi2Sp45MNcHghXDhKG2hu5PInTFy9+NaByDog 0WrjvsqZmHdqJfRsWudayiSX0+Iil9bzN63QRf3Zxk+vk6U2S3gqMe55K0J8R2lrgAUD 9EpkURN80IU4H35NGE7Ugghr0A0thW5PgLM+VmxWU/x5CCnzZamKMbWx+cntbpnefZuA Uaq1phxstXQuSV6M/VG67AzSozFFv+OkYoEGG1hkIikYbrKp+bkp2BlAb5wlow+pH/K0 rFo5HpeTis8XZ6LbZD7dglz+9GS9CCDui+ByUaS+AYxS+FN2JXbQleYN0Ui0J5t6OfdN OSfw== 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:dkim-signature; bh=99IEN6m5UElV9at56aBonJMIRnpZiJAMijW72c9+QT4=; fh=wzlgcYwqtz3FOCA4tMgrrjO/eA/mCNxQNvLbWrsvVUw=; b=hY7yGLnBLHW4N/tDKkC//IgyH+hWlBEtSZmdEa6nrT4fx8Ucr1O1SNOGhO/hCxnHxU UBovHt2F57Wh8OtCoakB9X4yd9l1qbVNWHyNouuwGClyrdcQb6SzcC3VT07EKZlTftDu 6qLWxBUYfaFM4PX90yRnWcHSRNrL6X31fjm0bBpmTMZMwMYOts5S4GN1D7XHjKyY2Oz9 Qv5GtMqYy3SnPLg3aRPMBk/SWucPi3/gQr68N+aAvD/5yDnR7iWQcSkWnbNEnhQy+oG3 NfSPyB4UaLR4KwMvgE6OR/c46VGM2nTKYXvED27eNFQ1JDrQOdjd5dDQBtnEtTJGH/93 bNOA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773252228; x=1773857028; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=99IEN6m5UElV9at56aBonJMIRnpZiJAMijW72c9+QT4=; b=TaRNbvH6CXVrD1Nn+EegjafDPNyz84jwzCnbFoz6msZuKtgovTnu4G10+Dfrb5taAl n4PMv20EkPg/BDX+gjNBKXk6f4tpbfXVXaa9wPptH8ddSIEvWH1ljqTavQHvW/YO8kdX REOrWft9p/r0aglAIjfd8ZBBS27huCI0WUS+0L7HqIXowJ3xrfnFR+4clWpkwo5WcxjG jHRdFmD0ZlwsiqvK8mSCM7q5srLpip54cz4vUQeKKAaVC9jqtBdPMHYShpkiYniIh3v3 zjvHTbDnPpQO533akcFq3nOqKjfQZcbGsCSsqKnnjiLNDsBDT/VVYutWciRZzlmLk8P4 rHaQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773252228; x=1773857028; 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=99IEN6m5UElV9at56aBonJMIRnpZiJAMijW72c9+QT4=; b=ACGOoXXHzfIpvqVEKz2HJVOu8yyy2BW9nkCtKJQ/+rfB64MU+KAtxOwEeedsYtlZhA SKEZ79fnYPpr2HmHAHvdXgznBQdr/LxcPaHS+P/uosofhhRpYVBHG3co3YI5A2Aa1BbB 2yqDfkmqxI0Ck2imvZzLhY7Bi7GTqI++0+bC17RNFWDW32NQ4leO2eihvlCcLpZm3bMa yzSnZ2nlBHNRw1P87XIoMlhavKryX1Fr/yjHpar0TVe9snRmqvf9fCSUznlHlHcqSDXr DsIXNzlq1u7c0N7YGTFdFzzdGO3GvNe+9krITXQPU3t6pDXsZnMTNskoRuAxeU46mowk d9BA== X-Gm-Message-State: AOJu0YwPrU+UscUaBpgZSYb930hu0xYg37rfa7dzd6zsaNx5e3Ef4NW3 zxgXvIzvQ2uGsTt/f6CXvt3gTYAhZdgrPMAi8zQaObCt4blHAcvlOLkQKtKtMAKmFBRYx2qx0lA gtmuSQFtsyvgoqr0a9uKH40AVtTAvzDc= X-Gm-Gg: ATEYQzw983xQutMJ4SGKWSttId0F4iQLBjZqw9dUzdFOlv87xCmImMM/f/+z7+FdUM2 OCVdltAVrQ1Vh/ZCWp10Nt/tqcGKYrLZ/xR6iFCdofhszlkAoSOLHmW0b393Kg3Q/GqdujyUbhy QZNI86mAntvUGlLvr4YExZjs2kvuVKz+RwrLKhouhxxMB3O4pRgeUPkTTfSZnyGRi2IyNU8ikBE kzmMOuWe3/TiOT2OUToLuriemrPY8F83BxvCTjaBX2FDPVBfQUUVdLsZ4LejYznOlWzW0UEEfCF 1AA8lGYOy7HVmorli0oGkzPLzOlGgXvLQfM6oXo1MalmHtnrQGPiMkq2fm4q//6aMX/mW7fc4gg XwScm2XOo X-Received: by 2002:a05:6402:35c1:b0:660:f443:379a with SMTP id 4fb4d7f45d1cf-66319cd6aa5mr1934589a12.15.1773252227896; Wed, 11 Mar 2026 11:03:47 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Melanie Plageman Date: Wed, 11 Mar 2026 14:03:36 -0400 X-Gm-Features: AaiRm53GhMLttfWunPsa6E8L7sw34sUBijSO97cTbcewZoiXHEmYqXwevA9P7oI Message-ID: Subject: Re: Unlogged rel fake lsn vs GetVictimBuffer() To: Andres Freund Cc: pgsql-hackers@postgresql.org, Heikki Linnakangas , Peter Geoghegan Content-Type: multipart/mixed; boundary="0000000000002457d5064cc37588" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002457d5064cc37588 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Mar 10, 2026 at 3:46=E2=80=AFPM Melanie Plageman wrote: > > Now, I'm thinking that I should allow BufferNeedsWALFlush() to be > called on local buffers. I removed it in v2 because Andres mentioned > it could never happen when called by StrategyRejectBuffer() (because > we don't use strategies on local buffers), but there's no reason > BufferNeedsWALFlush() can't be used more widely in the future. Well, due to 82467f627bd478569de, this is now a tiny one-liner. Will push in an hour or so barring objections. - Melanie --0000000000002457d5064cc37588 Content-Type: text/x-patch; charset="US-ASCII"; name="v3-0001-Avoid-WAL-flush-checks-for-unlogged-buffers-in-Ge.patch" Content-Disposition: attachment; filename="v3-0001-Avoid-WAL-flush-checks-for-unlogged-buffers-in-Ge.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mmmckw6s0 RnJvbSAwZTI2YThmNmI1NDEyMTQzMmYyYjVlZjc4NzY0Yzg1ODY1MjFjNzY2IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBNZWxhbmllIFBsYWdlbWFuIDxtZWxhbmllcGxhZ2VtYW5AZ21h aWwuY29tPgpEYXRlOiBXZWQsIDExIE1hciAyMDI2IDEzOjU3OjEzIC0wNDAwClN1YmplY3Q6IFtQ QVRDSCB2M10gQXZvaWQgV0FMLWZsdXNoIGNoZWNrcyBmb3IgdW5sb2dnZWQgYnVmZmVycyBpbgog R2V0VmljdGltQnVmZmVyKCkKCkdldFZpY3RpbUJ1ZmZlcigpIHJlamVjdHMgYSB2aWN0aW0gYnVm ZmVyIGlmIGl0IGlzIGZyb20gYSBidWxrcmVhZApzdHJhdGVneSByaW5nIGFuZCByZXVzaW5nIGl0 IHdvdWxkIHJlcXVpcmUgZmx1c2hpbmcgV0FMLiBVbmxvZ2dlZCB0YWJsZQpidWZmZXJzIGNhbiBo YXZlIGZha2UgTFNOcyAoZS5nLiB1bmxvZ2dlZCBHaVNUIHBhZ2VzKSBhbmQgY2FsbGluZwpYTG9n TmVlZHNGbHVzaCgpIG9uIGEgZmFrZSBMU04gaXMgbWVhbmluZ2xlc3MuCgpUaGlzIGlzIGEgYml0 IG9mIGZ1dHVyZS1wcm9vZmluZyBiZWNhdXNlIGN1cnJlbnRseSB0aGUgYnVsa3JlYWQgc3RyYXRl Z3kKaXMgbm90IHVzZWQgZm9yIHJlbGF0aW9ucyB3aXRoIGZha2UgTFNOcy4KCkF1dGhvcjogTWVs YW5pZSBQbGFnZW1hbiA8bWVsYW5pZXBsYWdlbWFuQGdtYWlsLmNvbT4KUmVwb3J0ZWQtYnk6IEFu ZHJlcyBGcmV1bmQgPGFuZHJlc0BhbmFyYXplbC5kZT4KUmV2aWV3ZWQtYnk6IEFuZHJlcyBGcmV1 bmQgPGFuZHJlc0BhbmFyYXplbC5kZT4KRWFybGllciB2ZXJzaW9uIHJldmlld2VkLWJ5OiBDaGFv IExpIDxsaS5ldmFuLmNoYW9AZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5l cy9tL2ZsYXQvZm1rcW15ZXl5N2JkcHZjZ2toZWI2eWFxZXdlbWtpazNsczZhYXZleWk1aWJtdnR4 bmQlNDBudTJrdnk1cnEzYTYKLS0tCiBzcmMvYmFja2VuZC9zdG9yYWdlL2J1ZmZlci9idWZtZ3Iu YyB8IDUgKysrLS0KIDEgZmlsZSBjaGFuZ2VkLCAzIGluc2VydGlvbnMoKyksIDIgZGVsZXRpb25z KC0pCgpkaWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvc3RvcmFnZS9idWZmZXIvYnVmbWdyLmMgYi9z cmMvYmFja2VuZC9zdG9yYWdlL2J1ZmZlci9idWZtZ3IuYwppbmRleCAwNTQ2ZWUwMTkzYy4uMjZi MTk1YjUzNTkgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3N0b3JhZ2UvYnVmZmVyL2J1Zm1nci5j CisrKyBiL3NyYy9iYWNrZW5kL3N0b3JhZ2UvYnVmZmVyL2J1Zm1nci5jCkBAIC0yNTI3LDggKzI1 MjcsOSBAQCBhZ2FpbjoKIAkJewogCQkJWExvZ1JlY1B0cglsc24gPSBCdWZmZXJHZXRMU04oYnVm X2hkcik7CiAKLQkJCWlmIChYTG9nTmVlZHNGbHVzaChsc24pCi0JCQkJJiYgU3RyYXRlZ3lSZWpl Y3RCdWZmZXIoc3RyYXRlZ3ksIGJ1Zl9oZHIsIGZyb21fcmluZykpCisJCQlpZiAoYnVmX3N0YXRl ICYgQk1fUEVSTUFORU5UICYmCisJCQkJWExvZ05lZWRzRmx1c2gobHNuKSAmJgorCQkJCVN0cmF0 ZWd5UmVqZWN0QnVmZmVyKHN0cmF0ZWd5LCBidWZfaGRyLCBmcm9tX3JpbmcpKQogCQkJewogCQkJ CUxvY2tCdWZmZXIoYnVmLCBCVUZGRVJfTE9DS19VTkxPQ0spOwogCQkJCVVucGluQnVmZmVyKGJ1 Zl9oZHIpOwotLSAKMi40My4wCgo= --0000000000002457d5064cc37588--