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 1w3fKy-001RCe-29 for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Mar 2026 19:16:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3fKx-007tDf-0P for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Mar 2026 19:16:47 +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.96) (envelope-from ) id 1w3fKw-007tDW-2i for pgsql-hackers@lists.postgresql.org; Fri, 20 Mar 2026 19:16:47 +0000 Received: from mail-ot1-x32e.google.com ([2607:f8b0:4864:20::32e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w3fKv-00000000DPE-22Xh for pgsql-hackers@postgresql.org; Fri, 20 Mar 2026 19:16:46 +0000 Received: by mail-ot1-x32e.google.com with SMTP id 46e09a7af769-7d75ed779bfso1808718a34.2 for ; Fri, 20 Mar 2026 12:16:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1774034205; x=1774639005; darn=postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=U3/D2TXTGyBOX0eFxD4Kz9r38ENAd3KbmvspatbT+Ew=; b=a10XgbboP64lXbKsKGHtEjtfP/z/G2XyX5VF2K8Mxy6cfwUbg5KLBJlSwzJo3zmnwM q103DuCBmkIvNYXJUvPmQdMpRTG+0V8VintH0n9Ij68D7znV0dYFsdU5r5K86QXmbH55 vWBsaOs6AoekHC2Ye2GQnUJe+NsIx2ClRiyelwB8+2FK558VWXgHMIo6pTTHWwviKwyn wyFFBBiF2I4HhQRhB98u+zK50LOAnxgPFwxviJj/dbtI9U3ZRf8Y5O0FxYnTlxuI7eOI IMBdx5pzAVfXtVVFl+0LQ6lrwza7I9irNaF//5YG0/XeJ8OvaRl/rTRSAYabrEYShlmM dM7A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774034205; x=1774639005; h=in-reply-to:content-transfer-encoding:content-disposition :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; bh=U3/D2TXTGyBOX0eFxD4Kz9r38ENAd3KbmvspatbT+Ew=; b=fJ9CbJznCE9JPoDOh//39RXcbT9DrIJth9QfFc1ZfG1cYcRQvXoUtnxVpVPKV25Azu 55x+yfGtI6kYed8dHpC0ogwKgeQXWTYZbph1m5I5EmftN5o1TUau1Q35qh0nmHZQ7kkw kwJkMW6UPi9IeQ5a1RIXQmZ6fIsSG2Id8JPg+iBAjX6kgjxVoYQFDZ7tbn4r7E/4y0W4 vYzz18I8iyBsmQLcQddhSlgn8+xAg1OUCmQqDcAo1VNNGhW9vs252wYeVe/7N1pQ782I v77y++aWFAH5h6YniFG2bakgEAtwa9EqNu3ZM9pAEZplCSqEMkBuSR2cQKXZiNfBci9Z 5FWg== X-Forwarded-Encrypted: i=1; AJvYcCXWVNU1A7iJkkW+cAZ25wWAzg0/ihtkVnxUc8YJYFzLkuVNCw5XzzP/ns9Ko5sgdDOOSb8IykW/5dNfnUNV@postgresql.org X-Gm-Message-State: AOJu0Yz9K9ct8Ni4TO5sQH8CcqgioAJ+zeFnHs1dRaoaxr0xFWTnm/do CEwdi/1IVvt815z7EyEbd4VEskU4rTDLemvx4dX0OdJXSQP86JQj/XmQ X-Gm-Gg: ATEYQzxL3iehxEzhwPpwhOfF28VqQ/CRLbTAMBTVQcugalYZuw7HjVUEAIfREZyoJVA 6Yr2oek4CSyO5N2+jwEdZqFfQM2+9tUuKgCq1KzPeve1gtaRDILh32UmkLBz3TPUYkfYVO5EIic bCdRntwZvyR6brc8i0fExOcMfTMHZiEjU3K33scPwrix5liCzzZYaWT3aEu+bSYWvwWMm+/tcQE ZAMt66hoNl4cOHW6F8Yav9wtnxCLGJPjZBcDV9KbCM6evu6luCd8vMULMyOsyjS7xQuw/4A+2H9 gHhl9wCEl+BGKnprUKEW5oTSrv46lCateRFzH5EM2aHdEDepZlZ4R4kzW/iVro0vDg0dP9BS6lH OGqYP6pC5QCHIjfKxB4ln++/tKtAsbGgCjOmBVrDRT5AVLaOrzF81yeYHth6lWHf67as7JDmSxP e1LsC2vARiOTtfQUaGajWkGsWc24tLeHCIn7wr7EdR2wIDE2LQQiXFvEdrdKIEN0jo78ZBMjimS Bv04S+lov2Ixvcd1Q/+7w== X-Received: by 2002:a05:6830:3885:b0:7d7:d1e1:6987 with SMTP id 46e09a7af769-7d7eafa5b08mr2576706a34.21.1774034204763; Fri, 20 Mar 2026 12:16:44 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 46e09a7af769-7d7eabe623dsm2978918a34.3.2026.03.20.12.16.43 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 20 Mar 2026 12:16:44 -0700 (PDT) Date: Fri, 20 Mar 2026 14:16:42 -0500 From: Nathan Bossart To: wenhui qiu Cc: Shinya Kato , pgsql-hackers@postgresql.org Subject: Re: enhance wraparound warnings Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Mar 09, 2026 at 08:08:54PM +0800, wenhui qiu wrote: > Thank you for working on this. The path LGTM,... Thanks for looking. Committed. > ...But I have a small request,There > are many reasons why the table's age can’t be frozen. Now have a path that > can report the reason to users(https://commitfest.postgresql.org/patch/6188/). > Would you be interested in reviewing it? I think we should tell users the > root cause of why the age can’t be reduced, so they can clearly understand > where the issue is.I think we should not only tell users that the XID is > close to wraparound, but also report why this causes the table‘s age to be > unable to freeze. Thanks for alerting me to this patch. -- nathan