| From: | Jim Vanns <jvanns(at)ilm(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: VACUUM on temp table blocks VACUUM on another... |
| Date: | 2024-08-01 19:58:06 |
| Message-ID: | CAH7vdhPRxVCMS5eCjfYFoixPU26=6O5f1gXPkj0YLGnqadmwUQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Sorry, PG15.
Jim
On Thu, 1 Aug 2024 at 20:25, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 8/1/24 12:12, Tom Lane wrote:
> > Jim Vanns <jvanns(at)ilm(dot)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(dot)klaver(at)aklaver(dot)com
>
>
--
Jim Vanns
Principal Production Engineer
Industrial Light & Magic, London
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Vanns | 2024-08-01 20:00:54 | Re: VACUUM on temp table blocks VACUUM on another... |
| Previous Message | Adrian Klaver | 2024-08-01 19:25:17 | Re: VACUUM on temp table blocks VACUUM on another... |