Postgres Pro
Downloads
Home   >   mailing lists

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

From Tsunakawa, Takayuki
Subject RE: Reaping Temp tables to avoid XID wraparound
Date
Msg-id 0A3221C70F24FB45833433255569204D1FB97BBE@G01JPEXMBYT05
Whole thread Raw
In response to Reaping Temp tables to avoid XID wraparound  (James Sewell <james.sewell@jirotech.com>)
Responses Re: Reaping Temp tables to avoid XID wraparound
List pgsql-hackers
Tree view 
From: James Sewell [mailto:james.sewell@jirotech.com]
> From the temp table namespace I can get the backend ID using a regex - but
> I have no idea how I can map that to a PID - any thoughts?
> 

SELECT pg_stat_get_backend_pid(backendid);

https://www.postgresql.org/docs/devel/monitoring-stats.html

This mailing list is for PostgreSQL development.  You can post questions as a user to
pgsql-general@lists.postgresql.org.


Regards
Takayuki Tsunakawa

pgsql-hackers by date:

Previous
From: "Tsunakawa, Takayuki"
Date:
Subject: RE: Protect syscache from bloating with negative cache entries
Next
From: Andrew Gierth
Date:
Subject: Re: Reaping Temp tables to avoid XID wraparound