Re: ALTER tbl rewrite loses CLUSTER ON index

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: ALTER tbl rewrite loses CLUSTER ON index
Дата
Msg-id 20200206144426.GH403@telsasoft.com
обсуждение исходный текст
Ответ на Re: ALTER tbl rewrite loses CLUSTER ON index  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: ALTER tbl rewrite loses CLUSTER ON index  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
I wondered if it wouldn't be better if CLUSTER ON was stored in pg_class as the
Oid of a clustered index, rather than a boolean in pg_index.

That likely would've avoided (or at least exposed) this issue.
And avoids the possibility of having two indices marked as "clustered".
These would be more trivial:
mark_index_clustered
/* We need to find the index that has indisclustered set. */



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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: bad logging around broken restore_command
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Do not check unlogged indexes on standby