On Mon, Dec 12, 2011 at 10:54 AM, Julien Tachoires <jul...@gmail.com> wrote: > 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 ? >
just as that... - create a table in a certain tablespace (diferent from pg_default), the toast table will be in the same tablespace, - then change the tablespace to pg_default and - then cluster the table... the toast table will be again in the same tablespace as the main table -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
