Re: Reaping Temp tables to avoid XID wraparound - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Reaping Temp tables to avoid XID wraparound
Date
Msg-id 20190218013102.GI1864@paquier.xyz
Whole thread Raw
In response to Re: Reaping Temp tables to avoid XID wraparound  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Reaping Temp tables to avoid XID wraparound  (James Sewell <james.sewell@jirotech.com>)
Re: Reaping Temp tables to avoid XID wraparound  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
On Sun, Feb 17, 2019 at 05:47:09PM +0100, Magnus Hagander wrote:
> We could I guess add a field specifically for temp_namespace_xid or such.
> The question is if it's worth the overhead to do that.

That would mean an extra 4 bytes in PGPROC, which is something we
could live with, still the use-case looks rather narrow to me to
justify that.

> Just having the namespace oid is at least enough to know that there is
> potentially something to go look at it. But it doesn't make for automated
> monitoring very well, at least not in systems that have a larger number of
> databases.

Yep.  It would be good to make sure about the larger picture before
doing something.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [PATCH] xlogreader: do not read a file block twice
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: RE: 2019-03 CF Summary / Review - Tranche #2