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 1wDPRa-002w4D-1K for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Apr 2026 16:19:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wDPRZ-006El6-29 for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Apr 2026 16:19:53 +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 1wDPRZ-006Ekx-17 for pgsql-hackers@lists.postgresql.org; Thu, 16 Apr 2026 16:19:53 +0000 Received: from mail-ed1-x534.google.com ([2a00:1450:4864:20::534]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wDPRW-00000001Qml-3LZ8 for pgsql-hackers@lists.postgresql.org; Thu, 16 Apr 2026 16:19:53 +0000 Received: by mail-ed1-x534.google.com with SMTP id 4fb4d7f45d1cf-671c24f23b1so6346963a12.0 for ; Thu, 16 Apr 2026 09:19:50 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776356385; cv=none; d=google.com; s=arc-20240605; b=GcZ1VQPgFCKcYTFj8JWMD+i/fY89B5eCqwJtF+de2Goi7b1Uu2mjQRlnpLiJntp7Yr 5+dp1AbtdkMcRwrPcBlTF/QUams5csmeblP9npDcaHoGkFlun6Sk2XaOaCuQaW0RTAow 8KNTabexoMlM9NaFyp0a8naOPXx+cg0lQGk+RoD1Zz3Qnz0Rza9RfE/ut22V1azkGLH+ Ymy7PVVnrqgqK9gGTuqJUie0y8pOdHgjEPIOc+dVicmPOg2PEM8VZyIaZK+JI420dgoz 2Fbwsw0oEDz56OwcLWxnZNrLaTmhBc81+EaxfIPBOedze4txBwQFw6J3OvZh4DgmMNbL ix0w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=elGYZAHTC32GpBpjrwZ1sgVyQCXgTY9kDSqqzpzLLMI=; fh=IuUKRMxBidkfA2Gne0LqBu240ZPkvJcHu11JB8Bu9nA=; b=RMcgMJtZAljQwk2xjwrTop1LKtJmiG4xUCKSmsV0SEzUdk3/Ikj3PsMRO0Xz0cgHBc 154f28iw0XAcwHtPLfu8trLaRlNacnjAWkYwW794z+6UsjyYuvZmav7i6Np9ws3HI+jb pIrWDCA9CalC94s7YQVvGFjneMxjPSmOa6ev+j2GwaOcc+us8cDPoB5tcCzLzwptosd/ Buvrb+Y+Lo2//xGGeALp3nU+SiDBStWi+dicYGHewIP2MXIOIKr/b2MrvFUv5+JMAq5B dkZvTN9a55Ai87sXXnhUyCK+HA4jHSjI2kG1pa1eJwrXepyI8RPUdPA/Ed7RJqmu9vXs Xkgg==; darn=lists.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=20251104; t=1776356385; x=1776961185; 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=elGYZAHTC32GpBpjrwZ1sgVyQCXgTY9kDSqqzpzLLMI=; b=R+RCtQwGkKaO+ukFifJD4RWYT2ZZ/+Tc/l7oLGkzMJnS3ajO4pAuswOnZ4PG/4ItIu El/zXW6uomeazSOK4ngAy0L/dJcpxAwP8m7BnCeBGODg3MEpZvNBCZoleSguqiC8TNos G1E/jgfsKCs6cSXS6hCt4HH7HQxTYtRxJWfzjGbTNzFCyw+6ruMoJRBbsfDDcY8vFPIB pNRJ3K5PKKYJDxVCN/M4hWcP4XzLUJviNevXuticg7vlgmU65K4XCnNFBOVOVLck+bsz j4vb6v3i92B3cCN9NtLJg4sYK6prxDvaCl0IeZZjjXFDfItj74OXD4ODpak3yN35MmV+ UmRA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776356385; x=1776961185; 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=elGYZAHTC32GpBpjrwZ1sgVyQCXgTY9kDSqqzpzLLMI=; b=mmxUGDm6nsVnBouCHW8th1mJr8wAHTC+rcNI08wXzVBEXJ3o7+nEeVYb7piYNOzd/y UhDLTwRZ1CcH+Ew4y1tX3C6TdWFJ1CABExrDwq82wKiR9PhJzb4zybUO+tB5wJj8+cJI QPuXDk6ToH4lRwgUMqGU9RjuXn0BpqJH3H07OCLwreVaOybx0uY3MKP7F+wnJ6aR32dR 9ZvhzmgelWUn6aoHYTtrq/AW2PbnZinCHcQ/QC86heQ2OPTwUGKqiJDwWNQcGn8lGD+Y EVmKM9L5cD6LcGFO0C9ZgYWCTpR7RTLeOPHXKD/r1dgH7cLbJcnTyi3stWgYZZxQGV3F DDBw== X-Forwarded-Encrypted: i=1; AFNElJ80kO9AEqDwMfbvRs4w3hQTKoz2PWypjxlBGO3ARXXCWPkzcBz3E+v5eY58tizYRQQI8uQHry/TwjmGMmmE@lists.postgresql.org X-Gm-Message-State: AOJu0YxM6AxdBOeLPZsdRiz2pjaBOsbdhAxFSNQA46eEvViQy4SKXbaR EMtk3FBwfHS1K6HyXUPPEosQEQe7/KuXOzy1hbOKNAA/vsfpnBsSKkTfAKD/ygWCTbLO/+FCW6a Fy4Tx10qPlS0kr3pSc4kIPGNRCTR17Dw= X-Gm-Gg: AeBDiets4/qOqY982Di7fcJNXLeeFKcAM3wcYBP+2JJjsWulLMIl0Le052BPMyIK/En UhlATSXJnR+Xuk51RLdIPfOjo6mNyVmM1oCMRUe8twciiTm4Fv2yQJ5dfqzkMxsel3JHVm60T1W AEa+FDoMVDm0t9iU/lcYPvlX2QCIGb3MBGMyLc1n6LCPE7uOlmFQXlGmsyj1CBex2DlYwdgdtiY i9OkFhO6sXAxml7y7Daav2RejAMMWi2VSX7yG+Sfv/R9ljC3f4eqy8QFmyYZEz+A/aNPsC+Wwmn uhEG0KRXjvRdFwdPUqcY+G//1iKQPLQf/d+qcQNo2BpJIZk0UP25rUiUgKzYgN6Xlj+tnQcMYyc LOzIh3tZPaSXX8s1yhIiBtaIMRXgiDw== X-Received: by 2002:a05:6402:3207:b0:672:40fd:d7cc with SMTP id 4fb4d7f45d1cf-67240fddf9bmr3811823a12.6.1776356384369; Thu, 16 Apr 2026 09:19:44 -0700 (PDT) MIME-Version: 1.0 References: <7clovcjtacv6peujpfaimeynrkcd4anp6ohbdd3ncgtjo67anb@ylcccepdiuz2> In-Reply-To: From: Melanie Plageman Date: Thu, 16 Apr 2026 12:19:32 -0400 X-Gm-Features: AQROBzBRdF7WzDWaEKspx-eUZ2g6uFv2NpLKBz_85_qO_S6Ydz-g6NIgrneYYRE Message-ID: Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) To: Alexey Makhmutov Cc: Andres Freund , PostgreSQL Hackers , Kirill Reshke , Andrey Borodin , 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 Mon, Apr 13, 2026 at 12:17=E2=80=AFPM Melanie Plageman wrote: > > The scenario causing inaccurate freespace maps after promotion is > technically possible though improbable. Moreover, I don't see a > downside to changing it. Patch I plan to commit is attached. I've committed this fix in b4c1b2be300. - Melanie