MIME-Version: 1.0
References: <CAH7vdhOhEb4H7UFD+JpOBrS-mOXAtR+vWP4TWD9xk20qHtgV8Q@mail.gmail.com>
 <3780009.1722539561@sss.pgh.pa.us>
In-Reply-To: <3780009.1722539561@sss.pgh.pa.us>
From: Jim Vanns <jvanns@ilm.com>
Date: Thu, 1 Aug 2024 21:00:54 +0100
Message-ID: <CAH7vdhNsEpRAhSEa4-KbLoRyjecixbnOqZa0_+yqR_t-oXKa1Q@mail.gmail.com>
Subject: Re: VACUUM on temp table blocks VACUUM on another...
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d1ec14061ea4abb8"
Archived-At: <https://www.postgresql.org/message-id/CAH7vdhNsEpRAhSEa4-KbLoRyjecixbnOqZa0_%2ByqR_t-oXKa1Q%40mail.gmail.com>
Precedence: bulk

--000000000000d1ec14061ea4abb8
Content-Type: text/plain; charset="UTF-8"

I don't at hand, but the query I used to identify this was;

SELECT state, pid, pg_blocking_pids(pid), query
FROM pg_stat_activity
WHERE backend_type='client backend';

On Thu, 1 Aug 2024 at 20:12, Tom Lane <tgl@sss.pgh.pa.us> 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?
>
>                         regards, tom lane
>


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

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

<div dir=3D"ltr">I don&#39;t at hand, but the query I used to identify this=
 was;<div><br></div><div>SELECT state, pid, pg_blocking_pids(pid), query<br=
>FROM pg_stat_activity<br>WHERE backend_type=3D&#39;client backend&#39;;<br=
></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail=
_attr">On Thu, 1 Aug 2024 at 20:12, Tom Lane &lt;<a href=3D"mailto:tgl@sss.=
pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex">Jim Vanns &lt;<a href=3D"mailto:jvanns@ilm.com"=
 target=3D"_blank">jvanns@ilm.com</a>&gt; writes:<br>
&gt; I have two sessions, each creating a temporary table of the same name =
-<br>
&gt; &#39;foobar&#39;. Why would a vacuum of &#39;foobar&#39; from one sess=
ion block the vacuum<br>
&gt; of &#39;foobar&#39; in the other session?<br>
<br>
That&#39;s fairly hard to believe.=C2=A0 Can you provide a self-contained t=
est<br>
case?<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<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>

--000000000000d1ec14061ea4abb8--