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';
Jim Vanns <jvanns@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