public inbox for [email protected]help / color / mirror / Atom feed
Re: VACUUM on temp table blocks VACUUM on another... 6+ messages / 3 participants [nested] [flat]
* Re: VACUUM on temp table blocks VACUUM on another... @ 2024-08-01 19:25 Adrian Klaver <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Adrian Klaver @ 2024-08-01 19:25 UTC (permalink / raw) To: Tom Lane <[email protected]>; Jim Vanns <[email protected]>; +Cc: [email protected] On 8/1/24 12:12, Tom Lane wrote: > Jim Vanns <[email protected]> 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 [email protected] ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: VACUUM on temp table blocks VACUUM on another... @ 2024-08-01 19:58 Jim Vanns <[email protected]> parent: Adrian Klaver <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Jim Vanns @ 2024-08-01 19:58 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: Tom Lane <[email protected]>; [email protected] Sorry, PG15. Jim On Thu, 1 Aug 2024 at 20:25, Adrian Klaver <[email protected]> wrote: > On 8/1/24 12:12, Tom Lane wrote: > > Jim Vanns <[email protected]> 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 > [email protected] > > -- Jim Vanns Principal Production Engineer Industrial Light & Magic, London ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: VACUUM on temp table blocks VACUUM on another... @ 2024-08-01 21:26 Ron Johnson <[email protected]> parent: Jim Vanns <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Ron Johnson @ 2024-08-01 21:26 UTC (permalink / raw) To: pgsql-general PG 15.0 or 15.7? On Thu, Aug 1, 2024 at 3:58 PM Jim Vanns <[email protected]> wrote: > Sorry, PG15. > > Jim > > On Thu, 1 Aug 2024 at 20:25, Adrian Klaver <[email protected]> > wrote: > >> On 8/1/24 12:12, Tom Lane wrote: >> > Jim Vanns <[email protected]> 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 >> [email protected] >> >> > > -- > Jim Vanns > Principal Production Engineer > Industrial Light & Magic, London > ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: VACUUM on temp table blocks VACUUM on another... @ 2024-08-01 22:13 Jim Vanns <[email protected]> parent: Ron Johnson <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Jim Vanns @ 2024-08-01 22:13 UTC (permalink / raw) To: Ron Johnson <[email protected]>; +Cc: pgsql-general PG 15.4 On Thu, 1 Aug 2024 at 22:27, Ron Johnson <[email protected]> wrote: > PG 15.0 or 15.7? > > On Thu, Aug 1, 2024 at 3:58 PM Jim Vanns <[email protected]> wrote: > >> Sorry, PG15. >> >> Jim >> >> On Thu, 1 Aug 2024 at 20:25, Adrian Klaver <[email protected]> >> wrote: >> >>> On 8/1/24 12:12, Tom Lane wrote: >>> > Jim Vanns <[email protected]> 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 >>> [email protected] >>> >>> >> >> -- >> Jim Vanns >> Principal Production Engineer >> Industrial Light & Magic, London >> > -- Jim Vanns Principal Production Engineer Industrial Light & Magic, London ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: VACUUM on temp table blocks VACUUM on another... @ 2024-08-01 22:31 Adrian Klaver <[email protected]> parent: Jim Vanns <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Adrian Klaver @ 2024-08-01 22:31 UTC (permalink / raw) To: Jim Vanns <[email protected]>; Ron Johnson <[email protected]>; +Cc: pgsql-general On 8/1/24 15:13, Jim Vanns wrote: > PG 15.4 Community edition or some variant? -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: VACUUM on temp table blocks VACUUM on another... @ 2024-08-02 07:38 Jim Vanns <[email protected]> parent: Adrian Klaver <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Jim Vanns @ 2024-08-02 07:38 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: Ron Johnson <[email protected]>; pgsql-general Official PGDB RPM build for Centos 7.9 On Thu, 1 Aug 2024 at 23:31, Adrian Klaver <[email protected]> wrote: > On 8/1/24 15:13, Jim Vanns wrote: > > PG 15.4 > > Community edition or some variant? > > > > > -- > Adrian Klaver > [email protected] > > -- Jim Vanns Principal Production Engineer Industrial Light & Magic, London ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-08-02 07:38 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-08-01 19:25 Re: VACUUM on temp table blocks VACUUM on another... Adrian Klaver <[email protected]> 2024-08-01 19:58 ` Jim Vanns <[email protected]> 2024-08-01 21:26 ` Ron Johnson <[email protected]> 2024-08-01 22:13 ` Jim Vanns <[email protected]> 2024-08-01 22:31 ` Adrian Klaver <[email protected]> 2024-08-02 07:38 ` Jim Vanns <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox