Re: Restore vacuum_delay_point() in GIN posting-tree leaf vacuum - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Restore vacuum_delay_point() in GIN posting-tree leaf vacuum
Date
Msg-id 33B92CF3-4BD1-40C0-91AA-D7F96D136730@yandex-team.ru
Whole thread
In response to Restore vacuum_delay_point() in GIN posting-tree leaf vacuum  (Paul Kim <mok03127@gmail.com>)
Responses Re: Restore vacuum_delay_point() in GIN posting-tree leaf vacuum
List pgsql-hackers

> On 19 Jul 2026, at 19:27, Paul Kim <mok03127@gmail.com> wrote:
> 
> no CHECK_FOR_INTERRUPTS()

As far as I remember, we hold a cleanup lock on posting tree root.
We cannot process interrupts while holding a LWLock.

I'm afraid to fix this problem we need a real page deletion with
full fledged concurrency protocol as we do it in B-tree or GiST.

I've written a patch for this in 2018. I hope to return to this one day.


Best regards, Andrey Borodin.



pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: Do not lock tables in get_tables_to_repack
Next
From: Ian Lawrence Barwick
Date:
Subject: Re: [PATCH] Add pg_get_event_trigger_ddl() function