RE: Reaping Temp tables to avoid XID wraparound

From: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
To: 'James Sewell' <james(dot)sewell(at)jirotech(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: Reaping Temp tables to avoid XID wraparound
Date: 2019-02-13 00:32:18
Message-ID: 0A3221C70F24FB45833433255569204D1FB97BBE@G01JPEXMBYT05
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

From: James Sewell [mailto:james(dot)sewell(at)jirotech(dot)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(at)lists(dot)postgresql(dot)org(dot)

Regards
Takayuki Tsunakawa

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Gierth 2019-02-13 00:38:51 Re: Reaping Temp tables to avoid XID wraparound
Previous Message Tsunakawa, Takayuki 2019-02-13 00:23:35 RE: Protect syscache from bloating with negative cache entries