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

Поиск
Список
Период
Сортировка
От Frédéric Yhuel
Тема Re: REINDEX blocks virtually any queries but some prepared queries.
Дата
Msg-id 45ef09cb-9c49-56b1-f548-6103f7dd0aaf@dalibo.com
обсуждение исходный текст
Ответ на Re: REINDEX blocks virtually any queries but some prepared queries.  (Michael Paquier <michael@paquier.xyz>)
Список 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 по дате отправления:

Предыдущее
От: Peter Smith
Дата:
Сообщение: Re: PG DOCS - logical replication filtering
Следующее
От: Peter Smith
Дата:
Сообщение: Re: PG DOCS - logical replication filtering