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.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sBFMV-00FLHQ-K1
	for pgsql-general@arkaria.postgresql.org; Sun, 26 May 2024 15:00:41 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sBFMU-004DVN-21
	for pgsql-general@arkaria.postgresql.org; Sun, 26 May 2024 15:00:38 +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.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sBFMS-004DVF-Lh
	for pgsql-general@lists.postgresql.org; Sun, 26 May 2024 15:00:37 +0000
Received: from fout4-smtp.messagingengine.com ([103.168.172.147])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sBFMM-0025Rj-VF
	for pgsql-general@lists.postgresql.org; Sun, 26 May 2024 15:00:35 +0000
Received: from compute1.internal (compute1.nyi.internal [10.202.2.41])
	by mailfout.nyi.internal (Postfix) with ESMTP id 294F313806A8;
	Sun, 26 May 2024 11:00:29 -0400 (EDT)
Received: from mailfrontend1 ([10.202.2.162])
  by compute1.internal (MEProxy); Sun, 26 May 2024 11:00:29 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:cc:content-transfer-encoding:content-type:content-type:date
	:date:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm3; t=1716735629;
	 x=1716822029; bh=cPLNImdqypxoEVm8KXM4K2zZx0tM8ECbQaYRsY4QrCU=; b=
	ILmh+7PJFzmfmeJdJI60P8nNlANvT/YGHpoiIiz8VYWteG17Wzpgu60wb8EoJC1a
	1XxYr4E6V+DwVNxVZJDcTxpXh+w+DMoNuRMnVjGYb8DrErk4QXY3bZnBjRdf5aG8
	rCaHLG48DezQl6VfZsjaOSNAvSmCi4//vRtNZUyEE8fRqdJ5aX6LxdRPfA7lMmzs
	5TF26/wQBeCY9G0NXSRWsHq7kevTTLUbEwxEDw7LMr3G1XknxIV+2nH11OE9JGWA
	o0B7rP1fvZnKvz1x1/0vidrZeJKQINJTXnT1ejtCk7Seva9POLw1V8RK8Gp1W2JZ
	4PwXzmiezxAaKog3DuVgJA==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-transfer-encoding
	:content-type:content-type:date:date:feedback-id:feedback-id
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1716735629; x=
	1716822029; bh=cPLNImdqypxoEVm8KXM4K2zZx0tM8ECbQaYRsY4QrCU=; b=I
	sVXAW2jkJjNVBjEYDyhMclDvIGTczUCH9KIG4SsUsc7u0QDkmDpw6Em+7KeVtjYg
	qyXl9KjfHB0BPtVH3bNm1rN32CDxv4EDv+gDTsEmnyfj6y0BPjIXV3kbRsYUGNgA
	zMXcHJFg1YnW8fC12I++rbb2W1GuyNrUFaHwJrTuutqOIamoVDTGPW12mkiqCy0V
	G+SzMTtttdwjeB/sQCW7bTgO7N6wELuwagBT6XquFHdP+11/GJ1cH8zwy3ZCCB7T
	bt0P9iWBt6H8iXNruY77zjM8dkWrMnkD8Cu4FRcLOyyQE1fSYpo9mfLVAzpejJ68
	mjAnD1Cp2D9rvOeCrWNBw==
X-ME-Sender: <xms:jE5TZjl9lM157kiOHo_815kawLp_bpQCAz7JT77auknCgfDLba3UCg>
    <xme:jE5TZm2jPBdQS-a-s8xo8H8M0eZr-w8BU1K0VLQcejnsoEhBztKTvNx9t4D3YAYlF
    dpb7jYD7Ke4k9E>
X-ME-Received: <xmr:jE5TZprbgYV4L4mf1IJIgykNPI0J_CRAllIF1VunwJ5RKexgV-23CGPFcCWEUx2_t-cwGkafEFZ8Cbz50nIbGi7HY66BRg>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrvdejvddgkedvucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucenucfjughrpefkffggfgfuvfevfhfhjggtgfesth
    ejredttddvjeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdr
    khhlrghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeeuudefje
    ejgffgtddtgeehgfekueevkeekieettedtkeffheeivdethfevffegueenucffohhmrghi
    nhepphhoshhtghhrvghsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptdenucfrrg
    hrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdr
    tghomh
X-ME-Proxy: <xmx:jE5TZrlIcsaBEKvK6liXXyPdfTfUdFTk80JfieEM08Q9Khd2Rx1jcA>
    <xmx:jE5TZh3xzuAVVpGOwU9U06iRZHhphGsPyg0dyn08EPwP-QoTa8gpSw>
    <xmx:jE5TZqtTX5KpJN2ldhl80a9jcYAMDzJy7BEjw4j_wjC78P0-nvVSfw>
    <xmx:jE5TZlXTA9ZzrGb1xa12hmXbWj9Ymib_WmoLKJ6xFcXGyiwB1owVeA>
    <xmx:jU5TZqxjoEVFCIOH2ZsZYt-zHyvpeNpJ7ADwY8OqjhB3Z1H7Qbj7bWt9>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun,
 26 May 2024 11:00:27 -0400 (EDT)
Message-ID: <ee222c6f-8137-4a69-aa61-c77f8a0c4c23@aklaver.com>
Date: Sun, 26 May 2024 08:00:26 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Long running query causing XID limit breach
To: David HJ <chuxiongzhong@gmail.com>, sud <suds1434@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
References: <CAD=mzVXR3GjM0vcthMBwEdbOKqSKcv8oojSS9coczWRi9BRYTA@mail.gmail.com>
 <CAKabb9XsSKEzmYV+WKPptLFPVYbqrD_W8UJKiQqW5euyS2HZoQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAKabb9XsSKEzmYV+WKPptLFPVYbqrD_W8UJKiQqW5euyS2HZoQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/ee222c6f-8137-4a69-aa61-c77f8a0c4c23%40aklaver.com>
Precedence: bulk

On 5/25/24 22:56, David HJ wrote:
> anyone know how to describe from this mailing list?

See here:

https://lists.postgresql.org/unsubscribe/


-- 
Adrian Klaver
adrian.klaver@aklaver.com