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.94.2) (envelope-from ) id 1uvevg-00Gune-Pa for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Sep 2025 16:41:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uvevf-0069B5-8P for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Sep 2025 16:41:19 +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.94.2) (envelope-from ) id 1uveve-0069Aw-Tj for pgsql-hackers@lists.postgresql.org; Mon, 08 Sep 2025 16:41:19 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uvevb-001EYf-1U for pgsql-hackers@lists.postgresql.org; Mon, 08 Sep 2025 16:41:18 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-b00a9989633so6863766b.0 for ; Mon, 08 Sep 2025 09:41:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1757349674; x=1757954474; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=7ja44AT7qusw6CLh5Aw81BgeKvr3lMuU8boJezIc6yE=; b=FH7R+qfd1riK5s7N8dp056R2hxNbMv4eBnRTgchMwh2OOyudsPjWP6yUxegpBN1px0 36khlSBIsPYNh68a6Y9nda2daZnrz9YzKkYFRpsqBKYtsSp4k5ZuJZshWEjbCndSeim+ 3gAeiopsMWuAHDiZaI8W9ADfkIZHk1BPMG3zlQ+kAKewCSqmR8LpdGfqkPC7ovWla73s bgid1X8f5dhRRafcYtwnXrOqWzeCblFX2OUjK5tR3mqAzGZh8gjZAeiwjXHCBR8HfwIJ CQAENLERE4SWTy/YY2hlmhXli/4eZF34GbBx1e1TlJYwlxpAFxlnwI60tGqT1X/dXDjW sH9A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757349674; x=1757954474; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=7ja44AT7qusw6CLh5Aw81BgeKvr3lMuU8boJezIc6yE=; b=eaYd+BESYwi3K59Z7azKNDKQUJ9xjqomZBCHU/MnURlQacKWdQBJ+lj617FBLWNV4+ Nkh7tbqiczn5/KorX90daE2kfOrIBkpxrJeBxmRtSDDOKaYlvpkpYUzDwbsLIQwArd5W Rl9mySv4NSkzYJ0VCNGyJBdfUqS8ExQ98N9DL0npjNcgX9dajdxg0NEToNGj5Y2HOexx Bo0CPP5ueFoQDAvcrTL/yQKYy1CueB0DOzTZkmEvDh4V5FpG0KYmKjB3v8BGdnVwGQmG QRuqKgFM+/2WYQ/qwyKboj5dpHEC/DzbC8LA/L5mno70QnXdIFJIaSRZ3aLqdBKPsLWx yNpA== X-Forwarded-Encrypted: i=1; AJvYcCXz3pNkzcddAdwO/JVxQqS4d5cr1ox7fiF1eVwSbJVj1GKUTjq/UW04ypCo4Fk63YaRTCHkMxkLBMc3QbHz@lists.postgresql.org X-Gm-Message-State: AOJu0YxulPJdEQCBT9mAC9VV1jLAp6bgrt/KQ0r9w2aF52ezgPxOe6YX n5HOifmVK0NfiHCuaswv8AkStZghQz6jdVIsVWE0i4XwROzHwYVYvIz1MQf/ky4CbyXQtgbpqT2 smp4uvym6iH8tJYDc4TG0qYbEvXqqrQlQJw== X-Gm-Gg: ASbGncsoWm0Z60nWCYPUznbw+TBKV5URmFUCCgJBspvin+3ly5oVKfI2bIHg3nZZPxe MO4J9DIwICNgcUH/irx1WuuhEApADrbHF8KYxg+b9t+hI6PMsnrgA0QLjeWF2TKFaA4vX8NLXfd iGBEZnnfGMOslRXpyCsMeJ6R43pZhNXUsc8P/Cf2iz65nN0hX3CqzRJM8wvimbaLVQSjQ1APaT0 xmCcqIruJQG7J4c4IY= X-Google-Smtp-Source: AGHT+IF0bXCz/Ssm/Tw/vx+FK6Eq6mw6GpzUQYbNDNZ7LQFs1RL/GJEU176JdoX5gRnAJBTPbgnwKyaCCimDMxdqcHI= X-Received: by 2002:a17:907:3f14:b0:afe:8ae2:a8fe with SMTP id a640c23a62f3a-b04b1e2c946mr1001988766b.14.1757349673840; Mon, 08 Sep 2025 09:41:13 -0700 (PDT) MIME-Version: 1.0 References: <87DD95AA-274F-4F4F-BAD9-7738E5B1F905@yandex-team.ru> In-Reply-To: From: Robert Haas Date: Mon, 8 Sep 2025 12:41:00 -0400 X-Gm-Features: Ac12FXwanHDeJYOv0J4p4Xob_r3mcpE2PfFcpPAophzDtt46blsAJbp-cbZX-78 Message-ID: Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) To: Melanie Plageman Cc: Andres Freund , Kirill Reshke , Andrey Borodin , PostgreSQL Hackers , Heikki Linnakangas Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Sep 5, 2025 at 6:20=E2=80=AFPM Melanie Plageman wrote: > yikes, you are right about the "reason" member. Attached 0002 removes > it, and I'll go ahead and fix it in the back branches too. I think changing this in the back-branches is a super-bad idea. If you want, you can add a comment in the back-branches saying "oops, we shipped a field that isn't used for anything", but changing the struct definition is very likely to make 0 people happy and >0 people unhappy. On the other hand, changing this in master is a good idea and you should go ahead and do that before this creates any more confusion. --=20 Robert Haas EDB: http://www.enterprisedb.com