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 1vQvy9-002Ovb-1o for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Dec 2025 23:09:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vQvy8-00GxUY-1a for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Dec 2025 23:09:08 +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 1vQvy8-00GxUQ-0e for pgsql-hackers@lists.postgresql.org; Wed, 03 Dec 2025 23:09:08 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vQvy6-002zzK-2Q for pgsql-hackers@lists.postgresql.org; Wed, 03 Dec 2025 23:09:08 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-b79b9113651so48521366b.3 for ; Wed, 03 Dec 2025 15:09:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1764803345; x=1765408145; 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=oKsTiW+r/u7g7T2dkmSQjTjV25q1DFD7pzbBtF6ZCy4=; b=am7oo2lPLQIwJnlFMQMdRQd5tDKvu2FK9/rxuOFmqgyazshSQUUyQ1D1ewMy6KTg58 L21xCXm27kfUC1ISrfN/Co8J7fD/Y2fyzZZ8n5aRYRs9VSi6vBIhVrP3YfVISqiBx/Im 2UqO6Fz6Gx+FbJgneh0iboKUyE6ZDc5y63//596RUgZBKYVQtGvfXD5c836DghUMj+wK fON5pa7N9eS9NX8kiJrC6r5V2Igdt6IymoXgCtiBxqDEf5AMXxuxkjV4cHIwSqwmX1tw FGM7kjp05Ry1e/OYiSpYU+LFtm7XTQDmc91P7rAfpXaxoeW9JAZKomIQH8c9xCG/J35M Dvfg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764803345; x=1765408145; h=content-transfer-encoding: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=oKsTiW+r/u7g7T2dkmSQjTjV25q1DFD7pzbBtF6ZCy4=; b=ixQ+L/b2F63Nrw2Zjr5K4BGDh8BLSQUQi4zwvMIT7160+3+IP1++DZQ5tQokMUJvVA ueydu6XEbZBvcRyU48wf7dufdDJpAhSmdfpq5rBxZF7zntbUKkHLRRP87C5auu7XG9Aj XU25TKfVRS8chzBgzxNT/xR/dfOVnlxjP+koAdDL6V3yIRukZUQUeWh7Quhd70h+7cy4 5V1xsJBShDHJ0fmR48eXWPFcYaX/aFJi+PvCHbhMGly014Wj69w1tkR3pHANgHXPHcU4 5uHWLcS6oYlxOMlvRqGe1glpoEgylYPkXjSfjUi8344MNcjADwVf+Ftk4MEi98TPBgps oJkg== X-Forwarded-Encrypted: i=1; AJvYcCVJGOTXLvDJ8pXBSN4miao4PfLlXekLOEzubq9TP+OEABJtNI0Q6sscr6Am9LeuEX2UETvEBLwXtyfTCKrV@lists.postgresql.org X-Gm-Message-State: AOJu0YwQFeL2KGYAGBmZLqI1IHB+aP2Myr+VfmfMV36rlWoLRJ/xv5nb 4rv/wOP0ysbuDt5VDaac8e8459k/eVItajL1+lGtUsTzVVA+sI/WQIRfBr1dutKVz6vvzKHm8CR zVCi4doMee5axEzOyczvm/PYitEyDXp8= X-Gm-Gg: ASbGncsw8Saj8Vg3DkpWoPlzb9MH6kak7lJvYo7lKBGYZQT/G+Kpod4vJOSfUUQMQuH 8ApPKlbo/7cYSq6VYDWDgONaGkGMlxebQgfB8gK34wk9mkkSvEuXe2phQIs7fEQ4rY3ewQDd0sn CA10Ff9Dy7wx5Dz54yfzbGXRGYdqrZL1kjJ6zyYxvqhB5wQxCNA2OTdpUI7bLztlFgbvASvDa2u nqQZUovvG4K9hfrwsZzA9z2bHlSVHxM7G3hfpFpp6N5Vwgx2dTeZPj4cjz5UTn11GYcwAGb X-Google-Smtp-Source: AGHT+IHpW20qJpXGhDYHVM34vZXVRp3GDoJ0014OyXP10p/VBIkGWbbEVjedRk9OzJ5qAcUZdo7UAixxacK1UwusAos= X-Received: by 2002:a17:907:948e:b0:b72:d117:1a29 with SMTP id a640c23a62f3a-b79ec6c9e5amr101357366b.51.1764803345461; Wed, 03 Dec 2025 15:09:05 -0800 (PST) MIME-Version: 1.0 References: <2wk7jo4m4qwh5sn33pfgerdjfujebbccsmmlownybddbh6nawl@mdyyqpqzxjek> <0AC177F5-5E26-45EE-B273-357C51212AC5@gmail.com> <45662821-41F0-4232-87B7-76A3B5E36BE1@gmail.com> In-Reply-To: <45662821-41F0-4232-87B7-76A3B5E36BE1@gmail.com> From: Melanie Plageman Date: Wed, 3 Dec 2025 18:08:53 -0500 X-Gm-Features: AWmQ_blLwIOgCcepJW0nVgngYS2bLW7oVYuOd0WU2djPsprwhWBD8uXHPvVt7a4 Message-ID: Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) To: Chao Li Cc: Kirill Reshke , Andres Freund , Robert Haas , 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 Mon, Nov 24, 2025 at 3:08=E2=80=AFAM Chao Li wr= ote: > > > On Nov 21, 2025, at 09:09, Chao Li wrote: > > > > I=E2=80=99d stop here today, and continue reviewing rest commits in nex= t week. > > I continue reviewing today. I incorporated all your feedback in my recently posted v23. Thanks for the review! - Melanie