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

2024-08-02 Thread Jim Vanns
*PGDG On Fri, 2 Aug 2024 at 08:38, Jim Vanns wrote: > Official PGDB RPM build for Centos 7.9 > > On Thu, 1 Aug 2024 at 23:31, Adrian Klaver > wrote: > >> On 8/1/24 15:13, Jim Vanns wrote: >> > PG 15.4 >> >> Community edition or some variant? >> >> >> >> >> -- >> Adrian Klaver >> adrian.kla...@a

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

2024-08-02 Thread Jim Vanns
Official PGDB RPM build for Centos 7.9 On Thu, 1 Aug 2024 at 23:31, Adrian Klaver wrote: > On 8/1/24 15:13, Jim Vanns wrote: > > PG 15.4 > > Community edition or some variant? > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > -- Jim Vanns Principal Production Engineer Industrial Lig

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

2024-08-01 Thread Adrian Klaver
On 8/1/24 15:13, Jim Vanns wrote: PG 15.4 Community edition or some variant? -- Adrian Klaver adrian.kla...@aklaver.com

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

2024-08-01 Thread Jim Vanns
PG 15.4 On Thu, 1 Aug 2024 at 22:27, Ron Johnson wrote: > PG 15.0 or 15.7? > > On Thu, Aug 1, 2024 at 3:58 PM Jim Vanns wrote: > >> 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 t

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

2024-08-01 Thread Ron Johnson
PG 15.0 or 15.7? On Thu, Aug 1, 2024 at 3:58 PM Jim Vanns wrote: > 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 - >> >> 'foob

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

2024-08-01 Thread Jim Vanns
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 wrote: > Jim Vanns writes: > > I have two sessions, each creating a temporary table of th

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

2024-08-01 Thread Jim Vanns
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 'fo

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

2024-08-01 Thread Adrian Klaver
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-contai

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

2024-08-01 Thread Tom Lane
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?