Re: VACUUM on temp table blocks VACUUM on another...

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Jim Vanns <jvanns(at)ilm(dot)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