Hi, 2011/12/10 Jaime Casanova <ja...@2ndquadrant.com>: > On Mon, Nov 28, 2011 at 1:32 PM, Julien Tachoires <jul...@gmail.com> wrote: > >>> 2) after CLUSTER the index of the toast table gets moved to the same >>> tablespace as the main table >> > > there is still a variant of this one, i created 3 tablespaces (datos_tblspc): > > """ > create table t1 ( > i serial primary key, > t text > ) tablespace datos_tblspc; > > ALTER TABLE t1 SET TOAST TABLESPACE pg_default; > CLUSTER t1 USING t1_pkey; > """
I am not able to reproduce this case, could you show me exactly how to reproduce it ? > >>> >>> now, if we are now supporting this variants >>> ALTER TABLE SET TABLE TABLESPACE >>> ALTER TABLE SET TOAST TABLESPACE >>> >>> why not also support ALTER TABLE SET INDEX TABLESPACE which should >>> have the same behaviour as ALTER INDEX SET TABLESPACE... just an idea, >>> and of course not necessary for this patch >>> > > any opinion about this? maybe i can make a patch for that if there is > consensus that it could be good for symettry Thanks, -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
