| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Assert while autovacuum was executing |
| Date: | 2023-06-22 04:30:01 |
| Message-ID: | CAA4eK1+jbOXVvJUNJTKFfaKR1Vrzj4piX-tgZmdA4s6pax3rNA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jun 21, 2023 at 11:53 AM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
>
> On Tue, Jun 20, 2023 at 10:27 PM Andres Freund <andres(at)anarazel(dot)de> wrote:
> > As far as I can tell 72e78d831a as-is is just bogus. Unfortunately that likely
> > also means 3ba59ccc89 is not right.
>
> Quite possibly. But I maintain that ginInsertCleanup() is probably
> also bogus in a way that's directly relevant.
>
> Did you know that ginInsertCleanup() is the only code that uses
> heavyweight page locks these days? Though only on the index metapage!
>
> Isn't this the kind of thing that VACUUM's relation level lock is
> supposed to take care of?
>
Yeah, I also can't see why that shouldn't be sufficient for VACUUM.
Assuming your observation is correct, what do you suggest doing in
this regard?
--
With Regards,
Amit Kapila.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2023-06-22 04:43:28 | Re: Making empty Bitmapsets always be NULL |
| Previous Message | shveta malik | 2023-06-22 04:12:56 | Re: Support logical replication of DDLs |