Re: Index corruption / planner issue with one table in my pg 11.6 instance

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Index corruption / planner issue with one table in my pg 11.6 instance
Дата
Msg-id CAH2-Wzk2XJUqVRqRTBVnaTKCW38FOJu7rJTzC1a6Ud_pFLB_CA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index corruption / planner issue with one table in my pg 11.6instance  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: Index corruption / planner issue with one table in my pg 11.6 instance  (Jerry Sievers <gsievers19@comcast.net>)
Список pgsql-hackers
On Mon, Dec 9, 2019 at 6:33 PM Michael Paquier <michael@paquier.xyz> wrote:
> Something new as of 11 is that btree indexes can be built in parallel,
> and before releasing it we found some bugs with covering indexes.
> Perhaps we have an issue hidden behind one of these, but hard to be
> sure.

I doubt it.

Jeremy did not report queries that give wrong answers. He only said
that the optimizer refused to use one particular index, before a
VACUUM FULL seemingly corrected the problem. OTOH, Jeremy did report
using contrib/amcheck on the index, which didn't complain. (Note also
that the amcheck functions will throw an error with an !indisvalid
index.)

-- 
Peter Geoghegan



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Windows UTF-8, non-ICU collation trouble
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: PATCH: logical_work_mem and logical streaming of largein-progress transactions