Thread: VACUUM on temp table blocks VACUUM on another...
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
Principal Production Engineer
Industrial Light & Magic, London
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
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
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
Principal Production Engineer
Industrial Light & Magic, London
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';
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
Principal Production Engineer
Industrial Light & Magic, London
PG 15.0 or 15.7?
On Thu, Aug 1, 2024 at 3:58 PM Jim Vanns <jvanns@ilm.com> wrote:
Sorry, PG15.JimOn 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
PG 15.4
On Thu, 1 Aug 2024 at 22:27, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
PG 15.0 or 15.7?On Thu, Aug 1, 2024 at 3:58 PM Jim Vanns <jvanns@ilm.com> wrote:Sorry, PG15.JimOn 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
Jim Vanns
Principal Production Engineer
Industrial Light & Magic, London
Principal Production Engineer
Industrial Light & Magic, London
On 8/1/24 15:13, Jim Vanns wrote: > PG 15.4 Community edition or some variant? -- Adrian Klaver adrian.klaver@aklaver.com
Official PGDB RPM build for Centos 7.9
On Thu, 1 Aug 2024 at 23:31, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 8/1/24 15:13, Jim Vanns wrote:
> PG 15.4
Community edition or some variant?
--
Adrian Klaver
adrian.klaver@aklaver.com
Jim Vanns
Principal Production Engineer
Industrial Light & Magic, London
Principal Production Engineer
Industrial Light & Magic, London
*PGDG
On Fri, 2 Aug 2024 at 08:38, Jim Vanns <jvanns@ilm.com> wrote:
Official PGDB RPM build for Centos 7.9On Thu, 1 Aug 2024 at 23:31, Adrian Klaver <adrian.klaver@aklaver.com> wrote:On 8/1/24 15:13, Jim Vanns wrote:
> PG 15.4
Community edition or some variant?
--
Adrian Klaver
adrian.klaver@aklaver.com--Jim Vanns
Principal Production Engineer
Industrial Light & Magic, London
Jim Vanns
Principal Production Engineer
Industrial Light & Magic, London
Principal Production Engineer
Industrial Light & Magic, London