MIME-Version: 1.0
References: <CAH7vdhOhEb4H7UFD+JpOBrS-mOXAtR+vWP4TWD9xk20qHtgV8Q@mail.gmail.com>
 <3780009.1722539561@sss.pgh.pa.us> <2583d693-f728-46d6-af57-5012cb223b28@aklaver.com>
 <CAH7vdhPRxVCMS5eCjfYFoixPU26=6O5f1gXPkj0YLGnqadmwUQ@mail.gmail.com>
In-Reply-To: <CAH7vdhPRxVCMS5eCjfYFoixPU26=6O5f1gXPkj0YLGnqadmwUQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 1 Aug 2024 17:26:40 -0400
Message-ID: <CANzqJaAysH3-+1vMBuUnOBc98=ko5-DuKDESoTXb13SAVjxjqw@mail.gmail.com>
Subject: Re: VACUUM on temp table blocks VACUUM on another...
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000007cb2c5061ea5dea0"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAysH3-%2B1vMBuUnOBc98%3Dko5-DuKDESoTXb13SAVjxjqw%40mail.gmail.com>
Precedence: bulk

--0000000000007cb2c5061ea5dea0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

PG 15.0 or 15.7?

On Thu, Aug 1, 2024 at 3:58=E2=80=AFPM 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
>

--0000000000007cb2c5061ea5dea0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>PG 15.0 or 15.7?</div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Thu, Aug 1, 2024 at 3:58=E2=80=AFP=
M Jim Vanns &lt;<a href=3D"mailto:jvanns@ilm.com">jvanns@ilm.com</a>&gt; wr=
ote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px=
 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D=
"ltr">Sorry, PG15.<div><br></div><div>Jim</div></div><br><div class=3D"gmai=
l_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, 1 Aug 2024 at 20:25,=
 Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_=
blank">adrian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">On 8/1/24 12:12, Tom Lane wrote:<br>
&gt; Jim Vanns &lt;<a href=3D"mailto:jvanns@ilm.com" target=3D"_blank">jvan=
ns@ilm.com</a>&gt; writes:<br>
&gt;&gt; I have two sessions, each creating a temporary table of the same n=
ame -<br>
&gt;&gt; &#39;foobar&#39;. Why would a vacuum of &#39;foobar&#39; from one =
session block the vacuum<br>
&gt;&gt; of &#39;foobar&#39; in the other session?<br>
&gt; <br>
&gt; That&#39;s fairly hard to believe.=C2=A0 Can you provide a self-contai=
ned test<br>
&gt; case?<br>
<br>
Would also be nice to know what version of Postgres and where you are <br>
running the server?<br>
<br>
&gt; <br>
&gt;=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0regards, tom lane<br>
&gt; <br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr">Jim Vanns<br>Principal Production Engineer<br>Industrial Lig=
ht &amp; Magic, London</div></div>
</blockquote></div></div>

--0000000000007cb2c5061ea5dea0--