Hi, 2011/12/10 Jaime Casanova <[email protected]>: > On Mon, Nov 28, 2011 at 1:32 PM, Julien Tachoires <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
