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.98.2) (envelope-from ) id 1xTBSo-00000000AWv-2Z4Y for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Nov 2026 05:10:39 +0000 Received: from localhost ([127.0.0.1]:41520 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xTBSm-00000002ng0-3U2R for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Nov 2026 05:10:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]:44586) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xTBSm-00000002nfs-28Zq for pgsql-hackers@lists.postgresql.org; Tue, 17 Nov 2026 05:10:36 +0000 Received: from mail-dy1-x132d.google.com ([2607:f8b0:4864:20::132d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xTBSk-000000007DO-1jxt for pgsql-hackers@lists.postgresql.org; Tue, 17 Nov 2026 05:10:36 +0000 Received: by mail-dy1-x132d.google.com with SMTP id 5a478bee46e88-381676b98e7so33716eec.1 for ; Mon, 16 Nov 2026 21:10:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20260707; t=1794892232; x=1795497032; darn=lists.postgresql.org; h=content-type:mime-version:references:in-reply-to:message-id:date :subject:cc:to:from:from:to:cc:subject:date:message-id:reply-to :content-type; bh=ONNWs2tZN3CDhuiBUoDYvdEB+25+2Rw7ybA90Y2NxUo=; b=IZvFDTki03yMukQPlpaIoK3jX0VnUg9wEIdXUMm84Iv6i4mFqIitpwlsXuQyPtA/FV vyAfvhfC8OEVvzYlgT/PE6MkB5fzfPKPflIMzDryO49AHY3WYVORf8Ai8spH7SZtQMkN Gj1jK3z0WoWpe1H//qg1zI8EJS0YonbNNX2GtGeaB1dSVG+tYJpcpuzCo56BlsF97Dfb NQIaWuLmM9Eo3KlFyoBsVurmNOcEeViRtXTWtpaxsl9lZdtO7ED9jTcsCmq/ezFDWIk1 aqhQKbFCLTVvKQDeoTcsgS6Mh31jN3gAp1wci0yj/YQQttRtHyaLwK6QKF4sqv2PYln6 Nluw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1794892232; x=1795497032; h=content-type:mime-version:references:in-reply-to:message-id:date :subject:cc:to:from:x-gm-gg:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to:content-type; bh=ONNWs2tZN3CDhuiBUoDYvdEB+25+2Rw7ybA90Y2NxUo=; b=Yx9+eOnU84sPH/vxFpruEPSZfj2mz7sFbhIQn8ZqBbzIqO85NEq8RUDHwk0iIRzOKF 7nTRIWPIUxK+vdWvXVYdW08joV23eqmcEZBtBnFZwa4CMGk8UnZc6Q9EAIIdl20FS4dB mJmcNEM7szzVRXn4FjZCBbtc5Y1763ILJYU7IprsGuxe3NGJEXe9GJHyBA3qzmxsZCDh U3HjIRzUXtg24sdfpgNHM93W/ca49YsHYBOuKU451wpx92IYdjcq6ShTfujRx6PnDvZu 7Rt0VH55W5MOgaEqULrvYARlbs1rAR5CpNpaKB6ihjgCWndsQm4bKLRCJSgRu2+fZnMG 4p5w== X-Forwarded-Encrypted: i=1; AL+hErFHihQo5Om1M1kNurH7G+JENFZBkDrMiVt242aCJTy/RfShoX/aqBYUV+WwYF8OwORLuckIB0y6sYDyVUTh@lists.postgresql.org X-Gm-Message-State: APuU4Z+44lAe37CzRkKNXWrVepBZ6u2Yl/B9QIjyUmhDDCl5ODztcdLS YMdT2BG0HjYL8tF+s828MrYracnfHCnAN1bs9KTWbJEc8AwLiiJ478i3 X-Gm-Gg: AYBFou0TMuFCPLtbb0sOuR4IsWKAim3QEocfsRFP4FUk/kClwXRpq7kKCmZf33WUrge RPrIeMvO+jBebAdMQ59bpHp+/HqROlI28Hkd/+TPB/K+0NSbPe/BF/BoJcQURZCKs+aVA18Whus qiFNJ4hKlOSSRm6yfFh2qQN2NzQSYLqxvt+vn1kX1US0wdCzDsVUJAd/XY77aGxcKrA/xWAJV7E HDv5Z9k18dN3AS/1BdeOouGm+jJvi2bV2ZdV2DJFBc8aBc4UJK1/az55Cbpa92B+O8+zm9Ce+BF RydTvj1804svqWWf1GtTgQ/cFUAwY+n8UtoC7CRONKayN5s9gaw+6owWeGHHqD7If9FnxtzO86T krzJ0VOFUAK6gvbct0q+5hb/rbDvd8F99GGxvI/nDhhBqQJ9x98mtys1ocinYR3susexdWvSErX ZQ3hZ0lKHo79Kn1gALE2q/EE0c/Jqf37HNAj4qIidDtePtRYVOjoFgYY5pXOiU+xQg92MR+G/BL QrHU2bEfc8NqrQIFCORQg/RMg3WW+s2rAMiGQ4sq70Ekls1hdvuMdAEVt5kmJADhBj1NPrNZGcr nnjZpwwTCuEM/kQbmjRaKsvdZw+VrUCfAtmU6gqGDKKptQH/Dlr1Yo8iI+7jubimZViNAkaSg3d 5lOgOotgZvxNh5gJ2RSP6a2VArtKB9UvkW2SqDj8qOL4SHna0IP9KI0U= X-Received: by 2002:a05:7022:7f04:b0:1a1:9106:cfff with SMTP id a92af1059eb24-1b503097baamr20027989c88.2.1794892231857; Mon, 16 Nov 2026 21:10:31 -0800 (PST) Received: from 192.168.1.109 ([190.12.171.184]) by smtp.gmail.com with ESMTPSA id a92af1059eb24-1b50316e195sm42656083c88.8.2026.11.16.21.10.30 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 16 Nov 2026 21:10:31 -0800 (PST) From: Manu To: Fujii Masao Cc: Michael Paquier , Melanie Plageman , pgsql-hackers@lists.postgresql.org Subject: Re: Assertion failure with temporary relations in single-user mode Date: Tue, 17 Nov 2026 02:10:24 -0300 Message-ID: <179489222449.37099.6261619082241419378@gmail.com> In-Reply-To: References: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4385705872745917960==" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4385705872745917960== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Hi Fujii, On Tue, Nov 17, 2026 at 1:41 PM Fujii Masao wrote: > I wonder if adding a new TAP test file might be overkill for this fix. Agreed. v2, attached, drops it and keeps only the fix in pgstat_io.c, plus the new row in the stats regression test's list of pg_stat_io rows. The code change is the same down to 16. The stats.out hunk differs on 18 and 19, and 16 and 17 have no such list; I can post those versions if they help. Regards, Manu --===============4385705872745917960== Content-Type: text/x-patch Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="v2-0001-Fix-IO-tracking-of-temporary-relations-in-single-.patch" MIME-Version: 1.0 RnJvbSA1MTM0MjBkYWY0MmQ4ZGY0NTQyYTk0ZDgyYmU5NjM5MDJjMmU5ZmQ2IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBNYW51ZWwgUmV5ZXMgQnJhdm8gPG1hbnVlbHJleWVzYnJhdm9A Z21haWwuY29tPgpEYXRlOiBNb24sIDE2IE5vdiAyMDI2IDIxOjE2OjU0IC0wMzAwClN1YmplY3Q6 IFtQQVRDSCB2Ml0gRml4IElPIHRyYWNraW5nIG9mIHRlbXBvcmFyeSByZWxhdGlvbnMgaW4gc2lu Z2xlLXVzZXIgbW9kZQoKcGdzdGF0X3RyYWNrc19pb19vYmplY3QoKSBsaXN0cyBCX1NUQU5EQUxP TkVfQkFDS0VORCBhbW9uZyB0aGUgYmFja2VuZAp0eXBlcyB0aGF0IG5ldmVyIGRvIElPIG9uIHRl bXBvcmFyeSByZWxhdGlvbnMsIHNpbmNlIDI4ZTYyNmJkZTAwICh2MTYpLgpBIGJhY2tlbmQgaW4g c2luZ2xlLXVzZXIgbW9kZSBleGVjdXRlcyBxdWVyaWVzIGxpa2UgYSBjbGllbnQgYmFja2VuZCwK YW5kIGNhbiBjcmVhdGUgYW5kIHVzZSB0ZW1wb3JhcnkgdGFibGVzIGFuZCBzZXF1ZW5jZXMuICBX aXRoIGFzc2VydGlvbnMKZW5hYmxlZCwgYW4gSU5TRVJUIGludG8gYSB0ZW1wb3JhcnkgdGFibGUs IENSRUFURSBURU1QIFRBQkxFIEFTIG9yCm5leHR2YWwoKSBvbiBhIHRlbXBvcmFyeSBzZXF1ZW5j ZSBmYWlscyB0aGUgYXNzZXJ0aW9uIGluCnBnc3RhdF9jb3VudF9pb19vcCgpOgoKICAkIGVjaG8g IkNSRUFURSBURU1QIFRBQkxFIHQgQVMgU0VMRUNUIDE7IiB8IHBvc3RncmVzIC0tc2luZ2xlIHBv c3RncmVzCiAgVFJBUDogZmFpbGVkIEFzc2VydCgicGdzdGF0X3RyYWNrc19pb19vcChNeUJhY2tl bmRUeXBlLCBpb19vYmplY3QsIGlvX2NvbnRleHQsIGlvX29wKSIpCgpXaXRob3V0IGFzc2VydGlv bnMsIHRoaXMgSU8gaXMgbm90IGNvdW50ZWQ6IHBnX3N0YXRfaW8gaGFzIG5vCiJ0ZW1wIHJlbGF0 aW9uIiByb3cgZm9yICJzdGFuZGFsb25lIGJhY2tlbmQiLgoKUmVtb3ZlIEJfU1RBTkRBTE9ORV9C QUNLRU5EIGZyb20gdGhpcyBsaXN0LCBhbmQgZml4IHRoZSBjb21tZW50IGFib3ZlCml0LiAgVGhl IHJlZ3Jlc3Npb24gdGVzdCB0aGF0IGxpc3RzIHRoZSByb3dzIG9mIHBnX3N0YXRfaW8gZ2FpbnMg dGhhdApyb3cuCgpEaXNjdXNzaW9uOgotLS0KIHNyYy9iYWNrZW5kL3V0aWxzL2FjdGl2aXR5L3Bn c3RhdF9pby5jIHwgMTQgKysrKysrKy0tLS0tLS0KIHNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv c3RhdHMub3V0ICAgIHwgIDMgKystCiAyIGZpbGVzIGNoYW5nZWQsIDkgaW5zZXJ0aW9ucygrKSwg OCBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC91dGlscy9hY3Rpdml0eS9w Z3N0YXRfaW8uYyBiL3NyYy9iYWNrZW5kL3V0aWxzL2FjdGl2aXR5L3Bnc3RhdF9pby5jCmluZGV4 IDNjOGZjYjIwLi5jZWM1NzU5NiAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvdXRpbHMvYWN0aXZp dHkvcGdzdGF0X2lvLmMKKysrIGIvc3JjL2JhY2tlbmQvdXRpbHMvYWN0aXZpdHkvcGdzdGF0X2lv LmMKQEAgLTQxMywxNiArNDEzLDE2IEBAIHBnc3RhdF90cmFja3NfaW9fb2JqZWN0KEJhY2tlbmRU eXBlIGJrdHlwZSwgSU9PYmplY3QgaW9fb2JqZWN0LAogCQlyZXR1cm4gZmFsc2U7CiAKIAkvKgot CSAqIEluIGNvcmUgUG9zdGdyZXMsIG9ubHkgcmVndWxhciBiYWNrZW5kcyBhbmQgV0FMIFNlbmRl ciBwcm9jZXNzZXMKLQkgKiBleGVjdXRpbmcgcXVlcmllcyB3aWxsIHVzZSBsb2NhbCBidWZmZXJz IGFuZCBvcGVyYXRlIG9uIHRlbXBvcmFyeQotCSAqIHJlbGF0aW9ucy4gUGFyYWxsZWwgd29ya2Vy cyB3aWxsIG5vdCB1c2UgbG9jYWwgYnVmZmVycyAoc2VlCi0JICogSW5pdExvY2FsQnVmZmVycygp KTsgaG93ZXZlciwgZXh0ZW5zaW9ucyBsZXZlcmFnaW5nIGJhY2tncm91bmQgd29ya2VycwotCSAq IGhhdmUgbm8gc3VjaCBsaW1pdGF0aW9uLCBzbyB0cmFjayBJTyBvbiBJT09CSkVDVF9URU1QX1JF TEFUSU9OIGZvcgotCSAqIEJhY2tlbmRUeXBlIEJfQkdfV09SS0VSLgorCSAqIEluIGNvcmUgUG9z dGdyZXMsIG9ubHkgcmVndWxhciBiYWNrZW5kcywgV0FMIFNlbmRlciBwcm9jZXNzZXMgZXhlY3V0 aW5nCisJICogcXVlcmllcyBhbmQgc3RhbmRhbG9uZSBiYWNrZW5kcyAoc2luZ2xlLXVzZXIgbW9k ZSkgd2lsbCB1c2UgbG9jYWwKKwkgKiBidWZmZXJzIGFuZCBvcGVyYXRlIG9uIHRlbXBvcmFyeSBy ZWxhdGlvbnMuIFBhcmFsbGVsIHdvcmtlcnMgd2lsbCBub3QKKwkgKiB1c2UgbG9jYWwgYnVmZmVy cyAoc2VlIEluaXRMb2NhbEJ1ZmZlcnMoKSk7IGhvd2V2ZXIsIGV4dGVuc2lvbnMKKwkgKiBsZXZl cmFnaW5nIGJhY2tncm91bmQgd29ya2VycyBoYXZlIG5vIHN1Y2ggbGltaXRhdGlvbiwgc28gdHJh Y2sgSU8gb24KKwkgKiBJT09CSkVDVF9URU1QX1JFTEFUSU9OIGZvciBCYWNrZW5kVHlwZSBCX0JH X1dPUktFUi4KIAkgKi8KIAlub190ZW1wX3JlbCA9IGJrdHlwZSA9PSBCX0FVVE9WQUNfTEFVTkNI RVIgfHwgYmt0eXBlID09IEJfQkdfV1JJVEVSIHx8CiAJCWJrdHlwZSA9PSBCX0NIRUNLUE9JTlRF UiB8fCBia3R5cGUgPT0gQl9BVVRPVkFDX1dPUktFUiB8fAotCQlia3R5cGUgPT0gQl9TVEFOREFM T05FX0JBQ0tFTkQgfHwgYmt0eXBlID09IEJfU1RBUlRVUCB8fAorCQlia3R5cGUgPT0gQl9TVEFS VFVQIHx8CiAJCWJrdHlwZSA9PSBCX1dBTF9TVU1NQVJJWkVSIHx8IGJrdHlwZSA9PSBCX1dBTF9X UklURVIgfHwKIAkJYmt0eXBlID09IEJfV0FMX1JFQ0VJVkVSOwogCmRpZmYgLS1naXQgYS9zcmMv dGVzdC9yZWdyZXNzL2V4cGVjdGVkL3N0YXRzLm91dCBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0 ZWQvc3RhdHMub3V0CmluZGV4IDhiMTU0NzEyLi5iMTkzNTg4MiAxMDA2NDQKLS0tIGEvc3JjL3Rl c3QvcmVncmVzcy9leHBlY3RlZC9zdGF0cy5vdXQKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC9zdGF0cy5vdXQKQEAgLTgxLDYgKzgxLDcgQEAgc3RhbmRhbG9uZSBiYWNrZW5kfHJlbGF0 aW9ufGJ1bGt3cml0ZQogc3RhbmRhbG9uZSBiYWNrZW5kfHJlbGF0aW9ufGluaXQKIHN0YW5kYWxv bmUgYmFja2VuZHxyZWxhdGlvbnxub3JtYWwKIHN0YW5kYWxvbmUgYmFja2VuZHxyZWxhdGlvbnx2 YWN1dW0KK3N0YW5kYWxvbmUgYmFja2VuZHx0ZW1wIHJlbGF0aW9ufG5vcm1hbAogc3RhbmRhbG9u ZSBiYWNrZW5kfHdhbHxpbml0CiBzdGFuZGFsb25lIGJhY2tlbmR8d2FsfG5vcm1hbAogc3RhcnR1 cHxyZWxhdGlvbnxidWxrcmVhZApAQCAtMTA0LDcgKzEwNSw3IEBAIHdhbHN1bW1hcml6ZXJ8d2Fs fGluaXQKIHdhbHN1bW1hcml6ZXJ8d2FsfG5vcm1hbAogd2Fsd3JpdGVyfHdhbHxpbml0CiB3YWx3 cml0ZXJ8d2FsfG5vcm1hbAotKDg4IHJvd3MpCisoODkgcm93cykKIFxhCiAtLSBMaXN0IG9mIHJl Z2lzdGVyZWQgc3RhdGlzdGljcyBraW5kcy4KIFNFTEVDVCBpZCwgbmFtZSwgZml4ZWRfYW1vdW50 LAotLSAKMi41Ni4xCgo= --===============4385705872745917960==--