Re: ltree_gist indexes broken after pg_upgrade from 12 to 13

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ltree_gist indexes broken after pg_upgrade from 12 to 13
Дата
Msg-id 712866.1646951810@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ltree_gist indexes broken after pg_upgrade from 12 to 13  (Alexander Korotkov <aekorotkov@gmail.com>)
Список pgsql-hackers
Alexander Korotkov <aekorotkov@gmail.com> writes:
> Sorry for publishing a patch, which doesn't even compile.
> The attached version should be good.

OK, better.

So to clarify: we are going to back-patch as far as v13, and
then in the minor releases we are going to tell people they
need to REINDEX all gist indexes on ltree?  If so, please
make that clear in the commit message, so I don't forget it
come May ;-)

Also, it looks like reindex is *not* required for indexes on
ltree[] ?  That is, gist_ltree_ops indexes are affected but
not gist__ltree_ops?

            regards, tom lane



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

Предыдущее
От: Mark Dilger
Дата:
Сообщение: Re: role self-revocation
Следующее
От: Nathan Bossart
Дата:
Сообщение: Re: Add index scan progress to pg_stat_progress_vacuum