Re: Do not lock tables in get_tables_to_repack - Mailing list pgsql-hackers

From Álvaro Herrera
Subject Re: Do not lock tables in get_tables_to_repack
Date
Msg-id al31_DPTruXg2Tw7@alvherre.pgsql
Whole thread
In response to Re: Do not lock tables in get_tables_to_repack  ("cca5507" <cca5507@qq.com>)
List pgsql-hackers
On 2026-Jul-11, cca5507 wrote:

> Bharath Rupireddy wrote:

> > + table_oid = IndexGetRelation(child_oid, true);
> > + if (!OidIsValid(table_oid))
> > + continue;
> > 
> > How about a short comment on why this is needed even with a lock on
> > the parent, since that lock doesn't cover lower-level leaves in a
> > multi-level partition tree?
> 
> I think it's worth a comment, too. Patch LGTM.

Thanks, added that and pushed.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Puedes vivir sólo una vez, pero si lo haces bien, una vez es suficiente"



pgsql-hackers by date:

Previous
From: shveta malik
Date:
Subject: Re: Support EXCEPT for TABLES IN SCHEMA publications
Next
From: Andrey Borodin
Date:
Subject: Re: Restore vacuum_delay_point() in GIN posting-tree leaf vacuum