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 1vLebV-006BMr-2y for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Nov 2025 09:35:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vLebT-00BpIf-29 for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Nov 2025 09:35:55 +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 1vLebT-00BpIW-1A for pgsql-hackers@lists.postgresql.org; Wed, 19 Nov 2025 09:35:55 +0000 Received: from mail-qt1-x835.google.com ([2607:f8b0:4864:20::835]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vLebQ-000Kuo-37 for pgsql-hackers@lists.postgresql.org; Wed, 19 Nov 2025 09:35:54 +0000 Received: by mail-qt1-x835.google.com with SMTP id d75a77b69052e-4ee05b2b1beso36402371cf.2 for ; Wed, 19 Nov 2025 01:35:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763544951; x=1764149751; darn=lists.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=6DGMvBcIu0yXfpF19K/coN1JfFhxblyOOIrfvtBrzOs=; b=F1KZ9IR/RS73V2p9XfmZrNFO5uhNOxVn46ldkyIuQSiHsQ7TJEbSrBJy8Uh9BTza/H z0gn3BgYcQQi5gMSMXA6+hIrqecdZMjBBRYnVa7mfY9Zb3+aXYuZfCv9ozFRAU9fpkb9 TDMEQwVPodQ6CVPwZu4h78NPlFgWZh/cu/Cf75T0gva5cmTU5xtPVD+5OQLhZgCEsqaY iqrQn++CUfWMFhwEuOKzlTq4m4MAn0YgHvoNGlFh9BigxxeQZyMglxVMHtDXqqD1XyR9 72pgfvKJWQfDLwQEasIaEAr1deHjhbBUfNo+dzSE4DlRToF/zzKvRUAahO7gzD4W4RSj AMOw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763544951; x=1764149751; 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=6DGMvBcIu0yXfpF19K/coN1JfFhxblyOOIrfvtBrzOs=; b=RII7RdwQg0Uxe++yaF9EsMndHWhzw2udCB6NCGsGXyqnaIwa3rh9MyDi7eZMfusC0L BmG1Uc9QAsBYcRQM8+Hf7pM/1Q8ocAfT0L/HKOQkkcV4ccXmJTDQ5BIvmyut7nCyiLqK T72U38weekoXNOzv1aL0RGMR1QuHyRNO9Du7ytrmYAZa2NxAP20xnUvwVH3hoq9hQub6 Yp/ZODYxAVVFlxezPsuS7sCMpmhr955Ua88t9OFRktOh8JhbSbqf5/PuH66pvrFEfoyQ AvPMJtckDyk0KTsBN3Swi9GKHUg5usvJKc3pGXRxewQEFqSPxJjiJXLUknEIQhaHSn8K AyxQ== X-Forwarded-Encrypted: i=1; AJvYcCV7yZ5fM2bopdfIyq5TdgCp12DIfnz7oTcqqy8287ni26C9hjtcHTyBXHSRFbZ9MFhjAKDZiNuQzxhISAMM@lists.postgresql.org X-Gm-Message-State: AOJu0YwE1br8cn2EcVd7ly5K9L1cWoK/jBmkySRBvSLuGJhA+l5RzuUU zd7oLvi1gD0C2+j2HPz4XlRn+EiCCktEJvLSXXFmcPZ3VwVek/zJTg0nEyJWxlh9FcpTgMjlpFl wUaeKXth6m9+QLOjxOgIMV8dXeKC5LZs= X-Gm-Gg: ASbGncuZGuF43XuLx2z5xdXQ7Vs7vFhgeGIGGX6jZiJRfNWajQWlU5suymHkhxgYsBv Fikxwgs5QnfSj/aXvdIkvpwnb+1AB//4bMOetFYuDh5BN6zaR6XqmZhOzfhRd9TBIMdBXI9sjcW WIvsTbBz7u20fzikCbUU2DX6iK7UDYoyYUYOwQ6S1y3iaf3+rF7i3RTGuXgOsFuu9AooloVt2a3 WYcVdsWhFeQaO3khR23n8zOy/drMk1rNKT5Izk1aNZYDglf9P/QVD+Z3OtXL58XplvAQSscOXgy LLico/Xa X-Google-Smtp-Source: AGHT+IHSce4GsBRNnPa4kYuTJ4HSDTj5Bbv6pEFtGO//3/XQD8ZhcqkXhMlV7iXKgGmYX5/m5q+qBmvq+AzMNnVmZlQ= X-Received: by 2002:ac8:5fc7:0:b0:4ee:1b53:ca6e with SMTP id d75a77b69052e-4ee40062d0bmr20539531cf.72.1763544950556; Wed, 19 Nov 2025 01:35:50 -0800 (PST) MIME-Version: 1.0 References: <2wk7jo4m4qwh5sn33pfgerdjfujebbccsmmlownybddbh6nawl@mdyyqpqzxjek> In-Reply-To: From: Kirill Reshke Date: Wed, 19 Nov 2025 14:35:39 +0500 X-Gm-Features: AWmQ_bn5cHNlLj2YUbrWDfX2NXi-8Z_yBOUnUI1WDV3RLTPms1dJ1oTTqRLpSRI Message-ID: Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) To: Melanie Plageman Cc: Andres Freund , Robert Haas , Andrey Borodin , PostgreSQL Hackers , Heikki Linnakangas Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 18 Nov 2025 at 04:07, Melanie Plageman wrote: > > Attached v20 has general cleanup, changes to the table/index AM > callbacks detailed below, and it moves the > heap_page_prune_and_freeze() refactoring commit down the stack to > 0004. > > 0001 - 0003 are fairly trivial cleanup patches. I think they are ready > to commit, so if I don't hear any objections in the next few days, > I'll go ahead and commit them. > Hi! I looked up these 0002-0003 patches once again, LGTM. In particular, I think 0002 & 0003 makes VM bits management more simple. My only review comment is about 0003: Should we make frz_conflict_horizon not a heap_page_will_freeze's argument but rather just another field of PruneState struct? If i'm not mistaken, 'frz_conflict_horizon' fits good to be a part of pruning state -- Best regards, Kirill Reshke