RE: Reaping Temp tables to avoid XID wraparound

From: Andrew Gierth [mailto:andrew(at)tao11(dot)riddles(dot)org(dot)uk]
> Tsunakawa> SELECT pg_stat_get_backend_pid(backendid);
>
> Doesn't work - that function's idea of "backend id" doesn't match the
> real one, since it's looking at a local copy of the stats from which
> unused slots have been removed.

Ouch, the argument of pg_stat_get_backend_pid() and the number in pg_temp_N are both backend IDs, but they are allocated from two different data structures. Confusing.

From: Michael Paquier [mailto:michael(at)paquier(dot)xyz]
> The temporary namespace OID is added to PGPROC since v11, so it could be
> easy enough to add a system function which maps a temp schema to a PID.
> Now, it could actually make sense to add this information into
> pg_stat_get_activity() and that would be cheaper.

That sounds good.

Regards
Takayuki Tsunakawa