Re: REINDEX CONCURRENTLY and indisreplident

Поиск
Список
Период
Сортировка
От Euler Taveira
Тема Re: REINDEX CONCURRENTLY and indisreplident
Дата
Msg-id CAH503wDaejzhP7+wA-hHS6c7NzE69oWqe5Zf_TYFu1epAwp6EQ@mail.gmail.com
обсуждение исходный текст
Ответ на REINDEX CONCURRENTLY and indisreplident  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: REINDEX CONCURRENTLY and indisreplident  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Дерево обсуждения
On Wed, 3 Jun 2020 at 03:54, Michael Paquier <michael@paquier.xyz> wrote:
Hi all,

I have bumped into $subject, causing a replica identity index to
be considered as dropped if running REINDEX CONCURRENTLY on it.  This
means that the old tuple information would get lost in this case, as
a REPLICA IDENTITY USING INDEX without a dropped index is the same as
NOTHING.

LGTM. I tested in both versions (12, master) and it works accordingly.


--
Euler Taveira                 http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: significant slowdown of HashAggregate between 9.6 and 10
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: significant slowdown of HashAggregate between 9.6 and 10