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';
FROM pg_stat_activity
WHERE backend_type='client backend';
On Thu, 1 Aug 2024 at 20:12, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Jim Vanns <jvanns@xxxxxxx> 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
Principal Production Engineer
Industrial Light & Magic, London
