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 1uuett-00Eo8G-0X for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Sep 2025 22:27: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 1uuetr-00Ansv-Ri for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Sep 2025 22:27:20 +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 1uuetr-00Ansm-I9 for pgsql-hackers@lists.postgresql.org; Fri, 05 Sep 2025 22:27:19 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uueto-000mcZ-2P for pgsql-hackers@lists.postgresql.org; Fri, 05 Sep 2025 22:27:19 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-61cebce2f78so3067337a12.1 for ; Fri, 05 Sep 2025 15:27:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1757111237; x=1757716037; 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=Gn5THXmfT4IZkHPq7o7OSsfsYmk0vUGnuYwEwD4PEhY=; b=RCMWX3na6dGbjW9Kv280lSgrcNl+k8j8rICZH97ijFobsKSb4yrAssWi/K0ZIeS2DG JEPooNrCRqVXV5HAFAyytsVHMCAIQkaHet5khytnjeRdShW9HNfl9tBzkpQo5jGUUkFY eEpsK5oxYYOa7vYc1pRBgC/qMafRoqJgoJs1dHx4SiWUGaMSCqg7e4z9joS8E8xn8jac lFZGiAJrdkZMgeC79wSR5bDJAvV6ifps3B0TuBeLe3twWEZsaezhPCYA2Z6uq9UkFSln hR5KknqMYLikrsk5NuscFL+6X+F5FQiZt7i/jn/KjKrDf9jsLXwMR4lfEjm5VdbveYr9 GolA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757111237; x=1757716037; 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=Gn5THXmfT4IZkHPq7o7OSsfsYmk0vUGnuYwEwD4PEhY=; b=FVLjWsJqyqQmR79AbFw9Y6XbW/OYIQ6PvaZfs1waP0rsmDpsHnAifBEpqjsqz4tEBq oZjOMqvRbQO43d8Nae9VHWtxl7jLrMeUtr0AT9Gm35ad8sgjTitCTcY43dpjiAGGeAYU xh6CLut1AWDHypofWxf7mujarBaASWxOfAU90UYqkk5iwYwpcDeW1mskKEf4DfSl1NVK v/FSnaGUPwdt30ZYELxvn3uQuNIyPCY5tF12n12rYuH2af5ldN3KQ/fLPLPA1EaHrhRC 483hGVN161DsvV9QsVLCTHXHMnJd7bGxiWgrTWOVGCuf+Nr0Ylht2Qk1tuvYFVuxDzv9 5HnA== X-Forwarded-Encrypted: i=1; AJvYcCXDsTLVEh3c5l/J6jRNxAFyC61l7vnUon1oT3t/zBX8GcKpZjPkC3vuMwXnYc5MfmAkrg3doXhqhoS/aObS@lists.postgresql.org X-Gm-Message-State: AOJu0YzK71IrO6/4MjicBOwo1SMEURhZtaVoDZkFCubBmJVk9VEbfbzh x3Y/qTGdd3gioT89B37G1ILB//SAl/gxZ4RB2x2tPXOwruHn96mY+LMzBPX5A1r5PkoYV21+wKe ouu0zc0tzouhjXm4dAmh3yI7qPZJu5B0= X-Gm-Gg: ASbGncuPQvQ5Cek8pb9bIQ6JVIGrbLgzlosGArqY2Pa78qnBaWjRJNj/J+VA2YGuHqy mvDLJ2eVknmlXb6YJxvHClGzPszzgn8u5G+MHiARhVWEBQ705HwdLMyzxL9Gk2E++qePNY3ahOF Ia8m8qaBrLWgo9Wi1ygRrOA7hLNRDn6gFZGlsQcwCyvycnmGUUwdfiFchjkUNjbHHzEURHfnLvq /QxWmI= X-Google-Smtp-Source: AGHT+IE9YdJoWb7C8+u4Pr7+P0mslwnXO91fSz9P3O7lEUbBdAeptf6kgW25PyJ5hrNTs3VGUXwxq6YGwMazmebKGj8= X-Received: by 2002:a05:6402:520d:b0:622:b89c:d4ae with SMTP id 4fb4d7f45d1cf-623805bc71cmr382734a12.34.1757111236408; Fri, 05 Sep 2025 15:27:16 -0700 (PDT) MIME-Version: 1.0 References: <87DD95AA-274F-4F4F-BAD9-7738E5B1F905@yandex-team.ru> In-Reply-To: From: Melanie Plageman Date: Fri, 5 Sep 2025 18:27:05 -0400 X-Gm-Features: Ac12FXz54ICZWjrspINeLfGpxg5zKp246qhkeQMLKbxklgy5I9dVuT4YohaDjXo Message-ID: Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) To: Kirill Reshke Cc: Andrey Borodin , PostgreSQL Hackers , Andres Freund , Robert Haas , 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 Wed, Sep 3, 2025 at 5:06=E2=80=AFAM Kirill Reshke wrote: > > small comments regarding new series > > 0001, 0002, 0017 LGTM Thanks for continuing to review! > In 0015: > > Also, maybe GlobalVisXidTestAllVisible is a slightly better name? (The > term 'all-visible' is one that we occasionally utilize) Actually, I was trying to distinguish it from all-visible because I interpret that to mean every thing is visible -- as in, every tuple on a page is visible to everyone. And here we are referring to one xid and want to know if it is visible to everyone as no longer running. I don't think my name ("visible-to-all") is good, but I'm hesitant to co-opt "all-visible" here. - Melanie