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

From Adrian Klaver
Subject Re: VACUUM on temp table blocks VACUUM on another...
Date
Msg-id 2583d693-f728-46d6-af57-5012cb223b28@aklaver.com
Whole thread Raw
In response to Re: VACUUM on temp table blocks VACUUM on another...  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: VACUUM on temp table blocks VACUUM on another...
List pgsql-general
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




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: VACUUM on temp table blocks VACUUM on another...
Next
From: Jim Vanns
Date:
Subject: Re: VACUUM on temp table blocks VACUUM on another...