On Thu, Dec 27, 2018 at 10:24 PM Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > > On 2018-Dec-27, Alexey Kondratov wrote: > > > To summarize: > > > > 1) Alvaro and Michael agreed, that REINDEX with tablespace move may be > > useful. This is done in the patch attached to my initial email. Adding > > REINDEX to ALTER TABLE as new action seems quite questionable for me and not > > completely semantically correct. ALTER already looks bulky. > > Agreed on these points.
As an alternative idea, I think we can have a new ALTER INDEX variants that rebuilds the index while moving tablespace, something like ALTER INDEX ... REBUILD SET TABLESPACE .... Regards, -- Masahiko Sawada NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center
