public inbox for [email protected]
help / color / mirror / Atom feedRe: 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]>
2024-08-01 19:58 ` Re: VACUUM on temp table blocks VACUUM on another... Jim Vanns <[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: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 ` Re: VACUUM on temp table blocks VACUUM on another... Ron Johnson <[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 19:25 Re: VACUUM on temp table blocks VACUUM on another... Adrian Klaver <[email protected]>
2024-08-01 19:58 ` Re: VACUUM on temp table blocks VACUUM on another... Jim Vanns <[email protected]>
@ 2024-08-01 21:26 ` Ron Johnson <[email protected]>
2024-08-01 22:13 ` Re: VACUUM on temp table blocks VACUUM on another... 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 19:25 Re: VACUUM on temp table blocks VACUUM on another... Adrian Klaver <[email protected]>
2024-08-01 19:58 ` Re: VACUUM on temp table blocks VACUUM on another... Jim Vanns <[email protected]>
2024-08-01 21:26 ` Re: VACUUM on temp table blocks VACUUM on another... Ron Johnson <[email protected]>
@ 2024-08-01 22:13 ` Jim Vanns <[email protected]>
2024-08-01 22:31 ` Re: VACUUM on temp table blocks VACUUM on another... Adrian Klaver <[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 19:25 Re: VACUUM on temp table blocks VACUUM on another... Adrian Klaver <[email protected]>
2024-08-01 19:58 ` Re: VACUUM on temp table blocks VACUUM on another... Jim Vanns <[email protected]>
2024-08-01 21:26 ` Re: VACUUM on temp table blocks VACUUM on another... Ron Johnson <[email protected]>
2024-08-01 22:13 ` Re: VACUUM on temp table blocks VACUUM on another... Jim Vanns <[email protected]>
@ 2024-08-01 22:31 ` Adrian Klaver <[email protected]>
2024-08-02 07:38 ` Re: VACUUM on temp table blocks VACUUM on another... 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-01 19:25 Re: VACUUM on temp table blocks VACUUM on another... Adrian Klaver <[email protected]>
2024-08-01 19:58 ` Re: VACUUM on temp table blocks VACUUM on another... Jim Vanns <[email protected]>
2024-08-01 21:26 ` Re: VACUUM on temp table blocks VACUUM on another... Ron Johnson <[email protected]>
2024-08-01 22:13 ` Re: VACUUM on temp table blocks VACUUM on another... Jim Vanns <[email protected]>
2024-08-01 22:31 ` Re: VACUUM on temp table blocks VACUUM on another... Adrian Klaver <[email protected]>
@ 2024-08-02 07:38 ` Jim Vanns <[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