Date: Thu, 11 Jun 2026 13:29:10 +0900
From: TAKATSUKA Haruka <harukat@sraoss.co.jp>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18876: HINT messages for mxid wrap-around say
 "drop stale slots", but that may not be appropriate
Message-Id: <20260611132910.50412ffa57bbc8e70bad8fc3@sraoss.co.jp>
In-Reply-To: 
 <CAHGQGwFKngUKWOM=N3sAOGCL95TjQf2jM8E3put7=cmGKHHg0A@mail.gmail.com>
References: <18876-0d0b53bad5a1f4c1@postgresql.org>
	<CAHGQGwFKngUKWOM=N3sAOGCL95TjQf2jM8E3put7=cmGKHHg0A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0: 
	=?utf-8?B?eTJuSjYzQVFoRSswc1o3blY4OWRXMG1zRXlHYTlISWR6YjkrdHI2L2dsZEVp?=
 =?utf-8?B?ZmNEbDByeDdtUTNyS2p4VnRBVVUwMGo2K292RkZiV1RtaThkZWVERjJ4Y1Y0?=
 =?utf-8?B?VEFwMGpxQnFRa1ROeGk1VDJnR0QzcXlQOTVXdXpWL0xyRXArSzZ1Q2p1dmxk?=
 =?utf-8?B?RjRiQnFqb2R1N2hvOU9wNGlVSWpNYkhTc3dWZWw0NUR1SjJNTEl3WC9vbXpn?=
 =?utf-8?B?MzhUbGhhU1Y2dkpraXZrdHF6QnZ2bUhVdDQvZkF3SnBTeG5rZU5JeDZIcnVi?=
 =?utf-8?B?SkQ1bW5vTitDWWExUmZTNGE1TElPNFlhTVZoUDVtWi9iVHdZSmVOS0dRVXlj?=
 =?utf-8?B?V0FWN1VtQlNwczYxd0pGWk1rcTdESm83ZXk2SUhVZGREZjlQeTVYemlMeHR4?=
 =?utf-8?B?RFlJNTZPRXU0OHBxQXNoWDNNSGEyRW1qRERiLy9IQ3I5MkNHSGRrQlNveEZX?=
 =?utf-8?B?NXRuaE5rYmJjckpmM3dPZ1JpVDZsZnhzRndRcVRuMllxVW1sL243bEgvbThI?=
 =?utf-8?B?ZUlBc2svMVVTRHBkYTZXU3YyWTc0V3VjVmpUTk51dkVWRkNickdsRGdDclhz?=
 =?utf-8?B?WE9HdXI1VE1lMGJTd1pWYnZOdk1nNk5Bc2J5WDRIRk5WOEhmWnd1aGdkT3NS?=
 =?utf-8?B?YXlidnlPNXc0MzJydlBXSnJvVlc4bnRKYnZHeXNtYnpLRjAxV3dxSFJsai80?=
 =?utf-8?B?ZUlERUVNYjY0bnZlY3NrRTFWdmJadU5zakhFcnJlNS91ejIwRWVlc3dmamVR?=
 =?utf-8?B?dC9JdVppZk42dmswSmV2MUtQZXNuRVlUNk9McXM0OElDRXVKUCsva2xaT3Fu?=
 =?utf-8?B?QytIdlhoemV1ekU5K2lKSytCeTJBZ2c4ZVNLNFFKSzZ4WEFVemxtUDA1Rktx?=
 =?utf-8?B?OEdnL0FwOFFmN3dyYWpGTHBHRkoyeWh3SFU5azhEK1YwenFWQjY0ODZrbElz?=
 =?utf-8?B?YXpDMjZBTVFyaCthUC9aNGZERFFEbjQ4Uk1RTndONTRUbXlDblJuam1kdlB5?=
 =?utf-8?B?YVVPV0RNeW54RnBVN2tlZmc0TmFDTFZ6L0dwNmJkM2NsbzI4cjk1OXR6d0xC?=
 =?utf-8?B?RXM4L3VnUHNEa0tnLy9UakZoYUg2NTBxMzgxMmRHOHpMdk5mQ2NUcm5jOGJm?=
 =?utf-8?B?ZFZRa2lCdG1rU0w3TGIzcE1hMWpuRHJXdFg2ektHZitqY1NTeXgrWk91QmFt?=
 =?utf-8?B?YThFUzJOcVVoT3dMT2pIeCtsVlFtMXlRU1Q2ZUQ4M2tqOUc2Z3pISGdQV3ZS?=
 =?utf-8?B?SkNYSUlURkE0SWFpMTArNHNUemZJMThSRU93ZU9KUE5vaFh4dW9kenFpcFhT?=
 =?utf-8?B?SkpnbVRPQVdHZmpNMmF6bm92QUExZG5LcW1kYWtGc1NPb3VXWWJRSW8ydGty?=
 =?utf-8?B?U0NFaW5xeGUvTmdmdGFXdmZYNnZjZDNtUXNuS0ppcno3REh1L2R5QzV4ZnNN?=
 =?utf-8?B?bUdCZ2pwcjNucXJuWm0rb0VNb3FiTGcrWUhPdFhQcUkvVmM2NkFOQzhaZ2Fh?=
 =?utf-8?B?QVI3LzNCYml2bmVleDJUemxQMWxjUVNEY2xlUENUV2tQU1RRZFc0N3p6QzAr?=
 =?utf-8?B?YWo4SVdRRG1wK1Q3aWlCaVNhc2xBN1RHZDBpZTNhdHZyVnNoRTFYbnU2MmZ4?=
 =?utf-8?B?MlBHVUhadUNxeHgrZVNuU1RJSU5kaWtrQXFZQm1UU0xXRjlpWjhyZEN1QzZn?=
 =?utf-8?B?RjhFUzFsOWlYZzEwMUxzbThCT1FCaWltZzBNazZNR0xiNGhjb0JPQi9GTVJM?=
 =?utf-8?B?ZFRRRDhrakxPdm5Vc0ZQQ1J2dGVBVHhmN3BHakIyT2NoMTN0RWFoSzZWYkFC?=
 =?utf-8?B?b29DU2JKcUhQWkw0Ulp5TUxlREhaVE5ISERkSFRVT3ZhUlRJZmgyY0cwMVpr?=
 =?utf-8?B?WVY0dVMwczBIUVZvM3A2RE5GN1NVeGNWWi85ZyszR2h5Y2RkMkdQNTR2VzR0?=
 =?utf-8?B?WU5TeUw1MllMMk5Gd0c3cXljb3ZvT2lMQURYeXZTenhuTjlJeDVScTJBU0k1?=
 =?utf-8?B?L016cUx5TS9DSVRtYVByQWhwTWN1WHVYSHhaYzVsd05UUzFDNGlLczU1cEx1?=
 =?utf-8?B?b09iUmV1SzVzTGE2NmNEZjM5K3BDbW1STDZJRG4yMGE1MXByRVhhb0lZRU5C?=
 =?utf-8?B?cVdCOWhld2tQWitrYnJYU1dvbGpsbDdmblE5MEtVNTd0NnpaY21tWjVNMmpJ?=
 =?utf-8?B?c2hoN3o0NWkrdENMRzNuNEQxZlZNZDFqV0s5a0dqRldXUVRDcDRsWklpMnhW?=
 =?utf-8?B?MlFjL1grTzAxWnpDUjBVMEJPYjdFSkpBZkJNZ0xNQUQ3ZGpNaWtadlMra1Vl?=
 =?utf-8?B?ay9ZZCtXc1dDSVhiSE52RVFROXRSNVAxQnVXUHdDTlVPU2VMVVFOdz09?=
X-OriginatorOrg: sraoss.co.jp
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 7414521d-d1a2-4770-c6c6-08dec771fc2e
X-MS-Exchange-CrossTenant-AuthSource: TYCP286MB3737.JPNP286.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 11 Jun 2026 04:29:11.0974
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 75db6c32-352e-4063-ae79-cafb8623f6db
X-MS-Exchange-CrossTenant-MailboxType: HOSTED
X-MS-Exchange-CrossTenant-UserPrincipalName: 
 HKTSKAU6gAlJjRnDnxds99KAk/f5OVvsOYyCagj95BecX/cZr3hQ6mf0ycTl/SULQPkyhfY9P36q2SNhioPZyw==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSOP286MB4270
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/20260611132910.50412ffa57bbc8e70bad8fc3%40sraoss.co.jp>
Precedence: bulk

Fujii-san

Thank you for incorporating my feedback into the code and documentation.

with best regards,
Haruka Takatsuka / SRA OSS K.K.


On Thu, 11 Jun 2026 12:31:28 +0900
Fujii Masao <masao.fujii@gmail.com> wrote:

> On Fri, Apr 4, 2025 at 10:30 PM PG Bug reporting form
> <noreply@postgresql.org> wrote:
> >
> > The following bug has been logged on the website:
> >
> > Bug reference:      18876
> > Logged by:          TAKATSUKA Haruka
> > Email address:      harukat@sraoss.co.jp
> > PostgreSQL version: 17.4
> > Operating system:   any
> > Description:
> >
> > In src/backend/access/transam/multixact.c, there are the following hint
> > messages:
> >
> >   "Execute a database-wide VACUUM in that database.\n"
> >   "You might also need to commit or roll back old prepared transactions, or
> > drop stale replication slots."
> >
> >   "To avoid MultiXactId assignment failures, execute a database-wide VACUUM
> > in that database.\n"
> >   "You might also need to commit or roll back old prepared transactions, or
> > drop stale replication slots."
> >
> > I think that their "drop stale replication slots" is not appropriate.
> >
> > Because NewRelminMxid is determined by GetOldestMultiXactId() and its
> > comment says:
> >    * Return the oldest MultiXactId that's still possibly still seen as live
> > by
> >    * any running transaction.  Older ones might still exist on disk, but
> > they no
> >    * longer have any running member transaction.
> >
> > Thus, the presence of an old mxid in a tuple pending removal by a slot is
> > not considered to affect it.
> >
> > In addition, as far as I have tested, leaving the old inactive replication
> > slot does not cause mxid_age(relminmxid) not to decrease after VACUUM.
> 
> I think you're right. So I prepared and attached a patch that refines
> the MXID wraparound hint messages. The patch also updates the
> documentation to clarify the relationship between replication slots and
> MXID wraparound.
> 
> Thought?
> 
> Regards,
> 
> -- 
> Fujii Masao