Re: ALTER tbl rewrite loses CLUSTER ON index

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: ALTER tbl rewrite loses CLUSTER ON index
Дата
Msg-id
20200302032818.GB32059@paquier.xyz
Ответ на
Re: ALTER tbl rewrite loses CLUSTER ON index (Justin Pryzby)
Список
Дерево обсуждения
ALTER tbl rewrite loses CLUSTER ON index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Amit Langote <amitlangote09@gmail.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ALTER tbl rewrite loses CLUSTER ON index (consider movingindisclustered to pg_class) Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index (consider moving indisclustered to pg_class) Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER tbl rewrite loses CLUSTER ON index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Michael Paquier <michael@paquier.xyz>
Re: ALTER tbl rewrite loses CLUSTER ON index Michael Paquier <michael@paquier.xyz>
Re: ALTER tbl rewrite loses CLUSTER ON index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER tbl rewrite loses CLUSTER ON index Amit Langote <amitlangote09@gmail.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Michael Paquier <michael@paquier.xyz>
Re: ALTER tbl rewrite loses CLUSTER ON index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Michael Paquier <michael@paquier.xyz>
Re: ALTER tbl rewrite loses CLUSTER ON index Michael Paquier <michael@paquier.xyz>
Re: ALTER tbl rewrite loses CLUSTER ON index Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Michael Paquier <michael@paquier.xyz>
Re: ALTER tbl rewrite loses CLUSTER ON index Michael Paquier <michael@paquier.xyz>
Re: ALTER tbl rewrite loses CLUSTER ON index Alvaro Herrera <alvherre@2ndquadrant.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Michael Paquier <michael@paquier.xyz>
Re: ALTER tbl rewrite loses CLUSTER ON index Michael Paquier <michael@paquier.xyz>
Re: ALTER tbl rewrite loses CLUSTER ON index (consider movingindisclustered to pg_class) Amit Langote <amitlangote09@gmail.com>
Re: ALTER tbl rewrite loses CLUSTER ON index (consider movingindisclustered to pg_class) Justin Pryzby <pryzby@telsasoft.com>
Re: ALTER tbl rewrite loses CLUSTER ON index Amit Langote <amitlangote09@gmail.com> 
On Sat, Feb 29, 2020 at 10:52:58AM -0600, Justin Pryzby wrote:
> Rebased Amit's patch and included my own 0002 to fix the REINDEX CONCURRENTLY
> issue.

I have looked at 0002 as that concerns me.

> +SELECT indexrelid::regclass FROM pg_index WHERE indrelid='concur_clustered'::regclass;
> +       indexrelid       
> +------------------------
> + concur_clustered_i_idx
> +(1 row)

This test should check after indisclustered.  Except that, the patch
is fine so I'll apply it if there are no objections.
--
Michael
В списке pgsql-hackers по дате отправления
Предыдущее
От: Michael Paquier
Дата:
Следующее
От: Dilip Kumar
Дата:
FAQ