VACUUM on temp table blocks VACUUM on another...

From: Jim Vanns <jvanns(at)ilm(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: VACUUM on temp table blocks VACUUM on another...
Date: 2024-08-01 15:54:49
Message-ID: CAH7vdhOhEb4H7UFD+JpOBrS-mOXAtR+vWP4TWD9xk20qHtgV8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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? They're in separate tablespaces
(pg_temp_NN) and effectively distinct with respect to the sessions.

Cheers,

Jim

--
Jim Vanns
Principal Production Engineer
Industrial Light & Magic, London

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-08-01 19:12:41 Re: VACUUM on temp table blocks VACUUM on another...
Previous Message Piotr Andreassen Blasiak 2024-08-01 14:18:54 Re: Logical replication slots on slaves/replicas?