I don't at hand, but the query I used to identify this was; SELECT state, pid, pg_blocking_pids(pid), query FROM pg_stat_activity WHERE backend_type='client backend';
On Thu, 1 Aug 2024 at 20:12, Tom Lane <t...@sss.pgh.pa.us> wrote: > Jim Vanns <jva...@ilm.com> writes: > > I have two sessions, each creating a temporary table of the same name - > > 'foobar'. Why would a vacuum of 'foobar' from one session block the > vacuum > > of 'foobar' in the other session? > > That's fairly hard to believe. Can you provide a self-contained test > case? > > regards, tom lane > -- Jim Vanns Principal Production Engineer Industrial Light & Magic, London
