Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZbwO-002CDz-LQ for pgsql-general@arkaria.postgresql.org; Thu, 01 Aug 2024 19:58:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sZbwN-00D6Gw-0r for pgsql-general@arkaria.postgresql.org; Thu, 01 Aug 2024 19:58:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sZbwM-00D6Go-Kz for pgsql-general@lists.postgresql.org; Thu, 01 Aug 2024 19:58:22 +0000 Received: from mail-io1-xd33.google.com ([2607:f8b0:4864:20::d33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sZbwK-002ewt-2P for pgsql-general@lists.postgresql.org; Thu, 01 Aug 2024 19:58:21 +0000 Received: by mail-io1-xd33.google.com with SMTP id ca18e2360f4ac-81f9339e534so260315839f.3 for ; Thu, 01 Aug 2024 12:58:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ilm.com; s=google; t=1722542298; x=1723147098; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=YbQ8YssTHSdh14EBfmIRK+qtCNHvObS+r86Y5o2DEfM=; b=Y0Ij7ZmyRr17Iv4+UqztJGPYwL+xU00dktNZEaU1J9lYmxabssDpcZVzK/8a+yHdZO sgfpQsE6lA3mHUS3dUQ1yOfXAN/SwtylPAIF3XoWlGR4z+Xrxr6onqAxsnaFIKm1Hrj4 RnPe6QFURhcOl0kKwik107V1NrPt/4lCMICB0= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1722542298; x=1723147098; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=YbQ8YssTHSdh14EBfmIRK+qtCNHvObS+r86Y5o2DEfM=; b=N9sB1iDyYlf+fULHKzLGtVZEBJn8OBz75658eC0SvojpnnwQr8nCByQijbfxF/3U90 EBDeoi/aMLuQUzhlZgKVZ8jkMnutvwB6O0+QWVzF6pdUjkAyeK1pu4HlEhF1IOquCmVB O8xh4GEdkQHK/HEoCZdfarUYOGsLhPCz55KBkCpNVosHEhb/Xq/TGB1IWa4nsyp2/vRT 56JoA4Hf26fr5VTykylJRCZ9J2J6KD0TYEIiJkPGE+dAi3arM7h1L9gMSWJjpCq9PAra lMqjGh4mtiz8MdbjbjVm/jD3mtBBqPKrBhEjTJwXpCisoNOqGLFVlhHTQekRD9nTHZpe QjOg== X-Forwarded-Encrypted: i=1; AJvYcCVmWhLaerp+uzgYfsyNKdoQ05Z2oHvBtxoIcvP97FYJKMLas6cbM2UQSkMSkVMGsKRIQGf1wGtlzrUSVuuRKGDAFQvMPAl5z7moR8eGs59tZGBz X-Gm-Message-State: AOJu0YxRMsHg536ifJhROBv5Lh5wchF6CxIDosobdeJzYD5iiHxS/N0y hCwaLRhuHMfwQuR0v3hze8W7XfGBhodUaJQPkOSeWA4JtNgIypzXVr3BfxzGKBBBWj4qgjBeoot lAPCsQ1UVb13FFdLAQ9p4yOYs9ePNhg2aFoeoXYncxckT/VwF X-Google-Smtp-Source: AGHT+IEnzuEJivXTXfH1b7LvB0Ljya1V6x10PYVMWojH3upq/kL67GQ27Z5d/BhNkrzqQCr5SUTHZL0sRvGXt0M1JQc= X-Received: by 2002:a05:6602:13d5:b0:7f6:2d58:8d6a with SMTP id ca18e2360f4ac-81fd43623eamr173426339f.7.1722542297857; Thu, 01 Aug 2024 12:58:17 -0700 (PDT) MIME-Version: 1.0 References: <3780009.1722539561@sss.pgh.pa.us> <2583d693-f728-46d6-af57-5012cb223b28@aklaver.com> In-Reply-To: <2583d693-f728-46d6-af57-5012cb223b28@aklaver.com> From: Jim Vanns Date: Thu, 1 Aug 2024 20:58:06 +0100 Message-ID: Subject: Re: VACUUM on temp table blocks VACUUM on another... To: Adrian Klaver Cc: Tom Lane , pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000c66908061ea4a173" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c66908061ea4a173 Content-Type: text/plain; charset="UTF-8" Sorry, PG15. Jim On Thu, 1 Aug 2024 at 20:25, Adrian Klaver wrote: > On 8/1/24 12:12, Tom Lane wrote: > > Jim Vanns 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 --000000000000c66908061ea4a173 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Sorry, PG15.

Jim

On Thu, 1 Aug 202= 4 at 20:25, Adrian Klaver <= adrian.klaver@aklaver.com> wrote:
On 8/1/24 12:12, Tom Lane wrote:
> Jim Vanns <jvan= ns@ilm.com> writes:
>> I have two sessions, each creating a temporary table of the same n= ame -
>> '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.=C2=A0 Can you provide a self-contai= ned test
> case?

Would also be nice to know what version of Postgres and where you are
running the server?

>
>=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
>
>

--
Adrian Klaver
adrian.klave= r@aklaver.com



--
Jim Vanns
Principal Production Engineer
Industrial Lig= ht & Magic, London
--000000000000c66908061ea4a173--