Re: VACUUM on temp table blocks VACUUM on another... - Mailing list pgsql-general

PG 15.0 or 15.7?

On Thu, Aug 1, 2024 at 3:58 PM Jim Vanns <jvanns@ilm.com> wrote:

Sorry, PG15.

Jim

On Thu, 1 Aug 2024 at 20:25, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

On 8/1/24 12:12, Tom Lane wrote:
> 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?

Would also be nice to know what version of Postgres and where you are
running the server?

>
>                       regards, tom lane
>
>

--
Adrian Klaver
adrian.klaver@aklaver.com

--

Jim Vanns
Principal Production Engineer
Industrial Light & Magic, London