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 1xCLWq-00000003jj6-008A for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Oct 2026 18:29:12 +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 1xCLWp-00000008OJi-0C8X for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Oct 2026 18:29:11 +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 1xCLWo-00000008OJa-2xVg for pgsql-hackers@lists.postgresql.org; Thu, 01 Oct 2026 18:29:10 +0000 Received: from mail-wm2-x11.google.com ([2a00:1450:4864:31::11]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xCLWm-00000002Et5-43G5 for pgsql-hackers@lists.postgresql.org; Thu, 01 Oct 2026 18:29:09 +0000 Received: by mail-wm2-x11.google.com with SMTP id 5b1f17b1804b1-49e721b5503so64985495e9.0 for ; Thu, 01 Oct 2026 11:29:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1790879347; x=1791484147; darn=lists.postgresql.org; h=message-id:date:content-id:content-type:mime-version:comments :references:in-reply-to:subject:cc:to:from:from:to:cc:subject:date :message-id:reply-to:content-type; bh=gitcm9ixA5gZ7IOaLy4SPzS904Z64aShirj/LKbEmBQ=; b=izZOMTMkzAbWLmwijSdcn3pxFBRPaTMh/mMNdelnX6U2e+4B1aiyf9Lxup1rjRJzgf m2FlYWgcgSxgTZvwnxDwHdETBQjUFxa4qJ55lIOfG94PyESEaizmzTriQbe/awGpg0Pn cKSKlCDObc42NOAK/NuxbMinwyPNxL48699F8foTKdRiUdnjedFhtaXQjr3dlRckkDS+ mhfPMI6v0ld2X3crznS4Ymo4Z/2aablglGmCGC+vrrXz7tYgbl4wid79XrlLNfE24WLo L32V/y6rqkF0gT29Z3MlI2ckqY90/ju5N21heJFsHz9EHS5zMDI6bL7LmlU1otmV2EM0 +Btg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1790879347; x=1791484147; h=message-id:date:content-id:content-type:mime-version:comments :references:in-reply-to:subject:cc:to:from:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=gitcm9ixA5gZ7IOaLy4SPzS904Z64aShirj/LKbEmBQ=; b=pZv7OkpfYxZnt6pHSWt0Tq1a1biRAEW1ALkz/6sEB+WmfUut72maeY9sd9X8tJzixC nkoChsLxzIYYuBB5LWU8N8juxHRzGlBsfS1+wub25olIEzxzcI2HuqC26yPeWgwUzigL qXotLTGkXWrknuR/vzGFliXydkKWLtaiGIKESIXr4vPc2ZZSTf+pVhdLeZIyUhrC41ju hw98HyjfzCqW0ZQBzDHWjkBqpOWa99cGwG0Lv43K+uIjPccGEqEjFTmxZNwuNJJhWY1X Am68mJBPbPxhu1ElgjyFBe6JL3lUDQbrGOTl8W+aa1CvwHX36z7LMgbn+0/KE3mFjFid IvRg== X-Forwarded-Encrypted: i=1; AKwUvBzgHISmvk39Pp03q48T8+r6+oTK6mHnDlUqUv14Oo030mwlfMOuiW9P+WgwvOba4WLNzGzbp9hJ00wUxOZx@lists.postgresql.org X-Gm-Message-State: AFuF++moWZ5lJRmZn+c3f60C57vUTZoQRhp7nWgOrwbY1m6JShUJKYbT VUX8wokJWr1rYeNlr4HrXwZgqinXFXvYGTj44J27h2sa1Lb8A33mim0MX3HjQjDtoTw= X-Gm-Gg: AYBFou3nR8MTcSoREpW84a5FPftBXucjqmG2lhTgmTj4PX8Z9ehuwLrFJ38F4nbyxuG hfUgltyIJPwSRR2IoN4QmIkJbSzrdxBxrao50kEQES+sSM1LnUGHPYnWBDPCWqEHdLrCJgeUMMa MZQLFNwqXc08zCWXAjT9DjDy75OaUfh+6mFcBSIHpRUzyXcEYbLLgTJ20xd0twTjSGy/f6bRRIg NAakvRXA/dukUD+6lW6XRdHAJjWwpMqugai7a8mqvnig4oguFnAobQvaosv6cL8JafsK8JfgI9C huRqmCq+sfxkMuiD4oy6cuyzmEfheXibfavlUreKIAPk/pvIOGqlJpNCY3K1SUDV2LJnGS/XQNQ qdNOrHbSsspA+SzXwzwoezP/Kt8vlC3O5H44uZLcHXWTjP7b3uqDzR9E1sMD+enBGU6790IpwPL rfNWmkVDnZ1uDHxZC6g1082inOdHg5cOHvT75gboi7QeqaAwkai8cKTa338HMqdsPXyeJcyMWWA ZugHwmDTA== X-Received: by 2002:a05:600c:c086:b0:4a0:236c:8601 with SMTP id 5b1f17b1804b1-4a0274568aamr9251615e9.0.1790879347037; Thu, 01 Oct 2026 11:29:07 -0700 (PDT) Received: from localhost (109-81-170-16.rct.o2.cz. [109.81.170.16]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4a0280bfafasm4548045e9.8.2026.10.01.11.29.06 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 01 Oct 2026 11:29:06 -0700 (PDT) From: Antonin Houska To: shihao zhong cc: Manu , pgsql-hackers@lists.postgresql.org Subject: Re: REPACK enhancements In-reply-to: References: <179004809718.4166269.6878292164216131831@gmail.com> <28303.1790158015@localhost> <163579.1790787537@localhost> Comments: In-reply-to shihao zhong message dated "Wed, 30 Sep 2026 21:28:01 -0600." X-Mailer: MH-E 8.6+git; nmh 1.8; GNU Emacs 28.3 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <28203.1790879346.1@localhost> Date: Thu, 01 Oct 2026 20:29:06 +0200 Message-ID: <28204.1790879346@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk shihao zhong wrote: > The compute_new_xmax_infomask() Assert is easy to hit. The > AccessExclusiveLock in rebuild_relation_finish_concurrent() assigns an > XID, so any UPDATE or DELETE committed while REPACK waits for it fails > on replay. The attached spec does it every time. Ah, I see, the assertion itself is wrong. Thanks. > If you give the new counter a slot that index builds don't write, > like 13, 0008 does not have to depend on 6958. It'd work, but if [1] gets merged, this workaround would be confusing. [1] https://commitfest.postgresql.org/patch/6958/ -- Antonin Houska Web: https://www.cybertec-postgresql.com