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 1x7vwZ-00000000oVR-0HGE for pgsql-hackers@arkaria.postgresql.org; Sat, 19 Sep 2026 14:21:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1x7vwX-000000059iK-46tx for pgsql-hackers@arkaria.postgresql.org; Sat, 19 Sep 2026 14:21:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1x7vwX-000000059iC-2rNa for pgsql-hackers@lists.postgresql.org; Sat, 19 Sep 2026 14:21:29 +0000 Received: from mail-pz2-x1f.google.com ([2607:f8b0:4864:3b::1f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1x7vwV-00000000CsK-21cI for pgsql-hackers@postgresql.org; Sat, 19 Sep 2026 14:21:28 +0000 Received: by mail-pz2-x1f.google.com with SMTP id 41be03b00d2f7-cc1cea50dc3so1156335a12.3 for ; Sat, 19 Sep 2026 07:21:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1789827686; x=1790432486; darn=postgresql.org; h=user-agent:in-reply-to:content-disposition:content-type :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to:content-type; bh=WMM+n5GdtiKFFmaXKofNVBZanV83gJ+tg8IfX6TMqoM=; b=NuP5caHAP3HGo7Ld+O6UKMWpeFdCjIxbMYeyf2RsOBEVMAk7w5Ffyt8F/Cl6o0whEZ AioxwxNavyVBtdsU7wwUmJnPcufapDJFuQeBMCHvyW38E6wb61rvJ+owyJPNNRFw2aWj IlVJybINB7f1KQRF7zynFoj2tqoQ3+2JWTigg= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1789827686; x=1790432486; h=user-agent:in-reply-to:content-disposition:content-type :mime-version:references:message-id:subject:cc:to:from:date:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=WMM+n5GdtiKFFmaXKofNVBZanV83gJ+tg8IfX6TMqoM=; b=SYVSL3AoMh0dcEiSWwprBpQ7yMxcIK2YMZOoKBzMchE8sbTvjcvTYSwYCZYMjZtq+U zACv5eKBwUD0fhivQehoYme7Q82tT8xgUNNi/VEsjdxjRDmH9EOvs61V4wDBIwB8wz6x I8drtAr2QJJQbYz8LK0+NNzqcd1aTyael0yzf25yEgTc57OoxrQ/PLRsOm+BDx8DYzlR KvXdwcUpl5kxASWFsxuOnoJs6tQT15qJFB13ooZZqDBXgllCo/0t9Ff1YtpKXcraNQkd thukdrx/OVCiTe9GayQ7EKwmzOz2SXwiBlzsPDrNqB5AmFq65yFg0TvFksZyiiIvBtMC MakA== X-Forwarded-Encrypted: i=1; AKwUvBya2h+3lmrkO/oDkvxBYjjq+cqp40Zeqa75TG3rHKSqKRL1kP5p8w1rG/q4AWa5ALocKkUVuc91KBuK0Kkp@postgresql.org X-Gm-Message-State: AFuF++msLWrQbr7Q8w8lKqEbKAAttMMzkEv+YfJk8L+dHdClqx5hwJeq uLmuGIFxpAo8ZKIvPlKwN3slDM/lOPmjYEc06BNk+r7KzKG1tjXjW7d7gKX/wOwNfw== X-Gm-Gg: AYBFou0ODMZN2XTsGYBMI8v5dN05m1fmEA71TWCK44mCUC/5kNHDR68z1CgpDJQ+HJD pHmbTuvvT8HlyPzELpVpjVAO0WqAFrHsF40gJnQ3mvHufZE6x3I5rdcaNYgI0QErzXIP2J6sNk+ +u4Xg1EgGIoqFLbMtq52M8oNcEPrI3MjXIna3PvN/LLP9+jyDkOhxs3/VT5ETX5IB8qicTeKd8a KHTLWkj1XUD+QMSRJGwneZtgr9cgm0IoDkDp6ZIGs1BEmf0ACDYpZGhIOVBS/8gl5jnxEko5Df8 VBawbzW+r58p4teiO+nr5la1GbTWxNARzF2vcQIeUeC6OJIJ+MaeucTobnuFiMrdRyMx9jc9zYQ AGu6pJCYwSNuWz93ELlCMndWdND2/XvPvqOq93CY/XHwShdoQjdrsYzFGz3apPBcPReXNEp9XEP o7OEhmEF4bBQLqiL4tQmMrTJieREtKgTce+RvGcyC3uj97Ovqth5q39YBMxppFP5rToZsRPxRNn /jIsABv0+NInBFtBebQLntlUEwmQoU= X-Received: by 2002:a17:90b:1cc4:b0:39d:f351:8f0c with SMTP id 98e67ed59e1d1-39e54dcb193mr10441729a91.13.1789827686128; Sat, 19 Sep 2026 07:21:26 -0700 (PDT) Received: from microsoft.com (c-73-15-160-255.hsd1.ca.comcast.net. [73.15.160.255]) by smtp.gmail.com with ESMTPSA id 5a478bee46e88-33c3313d907sm6295825eec.11.2026.09.19.07.21.24 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sat, 19 Sep 2026 07:21:24 -0700 (PDT) Date: Sat, 19 Sep 2026 07:21:22 -0700 From: Noah Misch To: Heikki Linnakangas Cc: orlovmg@gmail.com, pgsql-hackers@postgresql.org Subject: Re: 64-bit MultiXactOffset vs. 9.3->9.4 upgrade, pg_resetwal, "wraparound" msg Message-ID: <20260919142122.52.noahmisch@microsoft.com> References: <20260827231757.78.noahmisch@microsoft.com> <8fc26d4c-ff74-4cae-9c3d-db5c4f41d4ec@iki.fi> <20260917162105.56.noahmisch@microsoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.3.0 (2026-01-25) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Sep 18, 2026 at 09:15:38PM +0300, Heikki Linnakangas wrote: > From 866999c1251fbbde2f1d9db2799734c7c6e8fe54 Mon Sep 17 00:00:00 2001 > From: Heikki Linnakangas > Date: Fri, 18 Sep 2026 20:57:26 +0300 > Subject: [PATCH 1/1] Check that oldestXID and oldestMulti are consistent at > pg_upgrade I read this patch. It looks reasonable, and I expect it provides the intended defense. Thank you.