Re: More tests with USING INDEX replident and dropped indexes

Поиск
Список
Период
Сортировка
От Rahila Syed
Тема Re: More tests with USING INDEX replident and dropped indexes
Дата
Msg-id CAOajBXR19oHSbHch5oJvmN28Zwd_eRAZRoBNV__zJct572bLYQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: More tests with USING INDEX replident and dropped indexes  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Дерево обсуждения


On the other hand, it looks appealing to make index_set_state_flags()
transactional.  This would solve the consistency problem, and looking
at the code scanning pg_index, I don't see a reason why we could not
do that.  What do you think?

TBH, I am not sure.  I think it is a reasonable change. It is even indicated in the
comment above index_set_state_flags() that it can be made transactional.
At the same time, probably we can just go ahead with current
inconsistent update of relisreplident and indisvalid flags. Can't see what 
will break with that.  

Thank you,
--
Rahila Syed
Performance Engineer
2ndQuadrant 
http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: "k.jamison@fujitsu.com"
Дата:
Сообщение: RE: [Patch] Optimize dropping of relation buffers using dlist
Следующее
От: David Rowley
Дата:
Сообщение: Re: Hybrid Hash/Nested Loop joins and caching results from subplans