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 1wUYdG-001FlU-0N for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Jun 2026 23:34:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wUYdD-00GT3o-2q for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Jun 2026 23:34:47 +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 1wUYdD-00GT3c-1x for pgsql-hackers@lists.postgresql.org; Tue, 02 Jun 2026 23:34:47 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wUYdB-00000000wqs-09sr for pgsql-hackers@lists.postgresql.org; Tue, 02 Jun 2026 23:34:47 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-68c08bfe5afso4480013a12.2 for ; Tue, 02 Jun 2026 16:34:44 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1780443284; cv=none; d=google.com; s=arc-20240605; b=aB3FJ0tAWfVahXbTqxObxKSP2n+At2tQdKb+Nwq/35lMdTd5KweNyIarJOTKfsYYSH HJS171SnFVGJUGkqenxkZj0wYpoEYIcJu/FculK4obcugaQ2opb2iQ2itM2N/fSrj6hh iketP52g0IH+YGnkOm/Es9N3LUYbjL/byd3nq+rlN8KThLo+usGQ95a7RvaLRYK/MhFs 78RQk63/v4mszOv4WQyYkN3ld3BGO5D0xxBVxYWGQrCQK7zFA+6YiEQwqObahsmiLU2M jIYCje3zRRnXdmFWPNsXWdD1kD/CD33dX7K2jvdr9D/LxuzIkKVWuBMWeztr41i60Tzp ayqg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=qsvA37cA1do2ieiJzOWrQpnzqVSO6Srn0nD8C/6O6nk=; fh=eQ+XBCJ2Mte1jItk4BYK43zD/kNLYn9ue711+cb+hl8=; b=eFDm1UqrU4cWo8GbyYugkcQ02B1KPNLjCuXemiVlb+LHcAqNpuQCvALmTIYWlZ4dUi KYuXFEnJdJRshgqmByjW+RO99H3+G+QGRcAJVsI/mwy7uwsKdt1OFeLxu+VcBourDDFp mvQsXABuwzhsPwIA6OPN6ZJGXtzmcGs0idSN1rpuFhgO7VV6djc/KH5ZeE/LrEG6srem 92FdqkN8pJE538chyqu6XXjE8HBpZqbSzKMUddHy00P1uo6u+RWq9kYfeZBBhjbwMZFZ NZpn1x1a7bfND87cVfbGCba/IbKEDOpjQLBM5CrmZVHt0rOgrrdLIpTBcrO1am4/Qptf plXw==; 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=1780443284; x=1781048084; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=qsvA37cA1do2ieiJzOWrQpnzqVSO6Srn0nD8C/6O6nk=; b=aLfkxPXL0CYsF/5wOFqSBdMBe3CLh0huwrJ/MoNlDivdn8NimGs/uS17pBHm9Py3sZ XgEGAJul8xiHfZYhaqtcFVMMRWx1KuEUYMZCspqeSXUyQ30P8Ysa3BksMM7ZKX1lwD6C GWSs+Zyv54qH6KdaHMUdXxHsJlFo8bXQhg0vQ/+0e0U80ut4LU9xMvz7CkN09gw2G+wM KNKzmG6KxsjxEawZy3HXVB+My0+Fms6UyfVYyUs31rA54ZMeOLZypxaL8BsweOfSzthq PH0v7/QRgAOr4IPJpRqi5JhMatc78OZ7i3HO6Z6/mDBOqBpaRzmb/62kwIQsBgSff0X9 aqfA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780443284; x=1781048084; h=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=qsvA37cA1do2ieiJzOWrQpnzqVSO6Srn0nD8C/6O6nk=; b=kuL2/jy3vn9qA3iD6eTiABYFNzDkzScnp6jzDS3mcNAND2mAvXG1l6FdhoiC0xo+Ns lMstQWBeBa9eKYjIJrOgZkjTklxcDPdHfczfy6TMgmrImIm/cIWKU887tbofSerpP6nm C47P+s1uQ3s90E46caukrWc0GUOQ+jNE0z69VfmY3EndUWxG3EttqOpb0E2gfdDSfbRe IlMci5Lb1Wn2uWz1VzzE3UR2JcouC8RaKPxh47Lo4nDfLFu46mYN4TpZ9J5k8mVwGRTK 7XhhLqRr1gR6sxKWHxT7SG58wVoAvlNxlj/+APFzCfmIBUvy3e46WSnj6mFL83LM4qvn 1nbA== X-Forwarded-Encrypted: i=1; AFNElJ+1gmZfPw3Ia2Oy7hAbQvfXMh3FNrlsjhLaNZhbgm86925Sv9huavdFN6kXVD3NQ/CvzmJE/iXnR6FxffJP@lists.postgresql.org X-Gm-Message-State: AOJu0YzooULdcGS87OZaUJzm4ANfw2Eut60M2Cin905hLxryKE4McqQM wsnXWcoMecNDwTflyODVw/ZsigBhAiNFnHgjAwvKD3pvM5FUFo9Mt4oRMtinwg3I/a/v6TLd4yN Ndwmko2RxesxtUVgPdLzecFeLDhYR/rn3EaDF X-Gm-Gg: Acq92OEiHJIkJJzl6WHRz5Ksx2ho1ntX1pScLFl+E2E7zJblDhauCpc2MNgthVsvsXU ed0vJXdtgxdtyf6AiLE+cIVGGAF55BWt1z1acTvw1NKrey72zKMBM5J7PT4qU+zVSfeCOU/0I+5 e/ORfaT7QZJKRY+KAPf1lGm4ipxRc7SE6PESbmf9ozsFqYEOLCP5okoXYPPtcR/xinvQamwiq+R RWYnvFYyaUwPQxLm1aoL4pE+TMwkcnbHWVHQ6RSYAr5D6qgH6O4vq/hx3GXabZRHaWhAm/tR91l 7eWXCeV9ktCawTyvxEdAM+egTdg2dX3fPaxIll7iAJeXg42h X-Received: by 2002:a05:6402:27ce:b0:68a:9cf5:aba3 with SMTP id 4fb4d7f45d1cf-68e710f83a6mr274811a12.19.1780443283767; Tue, 02 Jun 2026 16:34:43 -0700 (PDT) MIME-Version: 1.0 References: <6634e1b0b5b74e5c2e3b06201120a81e11d82a55.camel@cybertec.at> <3bnBUxwx2npXqvHL0trI11LOOvzQ7LI0GzWqbaj5SJnk7DTb1uzStGveKwj0JJmBW4ebzGIF3az7of4I4rQeaO_PRqDnnClCduPyjM6gPgM=@scottray.io> <20260602.165755.1084850050958933598.horikyota.ntt@gmail.com> In-Reply-To: <20260602.165755.1084850050958933598.horikyota.ntt@gmail.com> From: Sami Imseih Date: Tue, 2 Jun 2026 18:34:32 -0500 X-Gm-Features: AVHnY4I0oOJP_O4SwTFy-oghkm0lKLU4pt9X0TysLzIusmXw61txWTumSrR6F0A Message-ID: Subject: Re: Report oldest xmin source when autovacuum cannot remove tuples To: Kyotaro Horiguchi Cc: shinya11.kato@gmail.com, scott@scottray.io, laurenz.albe@cybertec.at, japinli@hotmail.com, qiuwenhuifx@gmail.com, pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, > This may be just my personal preference, but I'd rather see > information about xid horizon retention exposed through a SQL-visible > interface than added to the VACUUM log. > > VACUUM VERBOSE already reports the removable cutoff and how old it was > when the operation ended. That seems sufficient as a signal that the > xid horizon is being held back. > > What I would want to investigate after seeing such a signal is not > necessarily what happened to be blocking that particular VACUUM > operation at some earlier point, but what is holding the xid horizon > back now. For that purpose, a view exposing the current xid/xmin > holders seems more useful and less misleading than adding a > best-effort blocker guess to the VACUUM log. +1, I also had a similar comment at the bottom of [1], where this information is better to be exposed in SQL for proactive monitoring. [1] https://www.postgresql.org/message-id/CAA5RZ0sjMgMo4Xg-niyyF-CpkQ_CK6uOfNKYT%3D9RmiBkAxQkbQ%40mail.gmail.com -- Sami Imseih Amazon Web Services (AWS)