Re: REINDEX blocks virtually any queries but some prepared queries.

From: Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: REINDEX blocks virtually any queries but some prepared queries.
Date: 2022-04-11 07:06:07
Message-ID: 45ef09cb-9c49-56b1-f548-6103f7dd0aaf@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Smith 2022-04-11 07:09:02 Re: PG DOCS - logical replication filtering
Previous Message Peter Smith 2022-04-11 07:03:55 Re: PG DOCS - logical replication filtering