Re: REINDEX blocks virtually any queries but some prepared queries. - Mailing list pgsql-hackers

From Frédéric Yhuel
Subject Re: REINDEX blocks virtually any queries but some prepared queries.
Date
Msg-id 45ef09cb-9c49-56b1-f548-6103f7dd0aaf@dalibo.com
Whole thread Raw
In response to Re: REINDEX blocks virtually any queries but some prepared queries.  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers

On 4/11/22 02:57, Michael Paquier wrote:
> On Fri, Apr 08, 2022 at 04:23:48PM +0200, Frédéric Yhuel wrote:
>> Thank you Michael.
> 
> And done as of 8ac700a.
> --

Thank you Micheal!

For reference purposes, we can see in the code of get_relation_info(), 
in plancat.c, that indeed every index of the table are opened, and 
therefore locked, regardless of the query.

Best regards,
Frédéric



pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: PG DOCS - logical replication filtering
Next
From: Peter Smith
Date:
Subject: Re: PG DOCS - logical replication filtering