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

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: VACUUM on temp table blocks VACUUM on another...
Дата
Msg-id CANzqJaAysH3-+1vMBuUnOBc98=ko5-DuKDESoTXb13SAVjxjqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: VACUUM on temp table blocks VACUUM on another...  (Jim Vanns <jvanns@ilm.com>)
Ответы Re: VACUUM on temp table blocks VACUUM on another...
Список 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

В списке pgsql-general по дате отправления: