From: | Julien Tachoires <julmon(at)gmail(dot)com> |
---|---|
To: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: patch : Allow toast tables to be moved to a different tablespace |
Date: | 2011-12-12 15:54:54 |
Message-ID: | CAFEQCbGmVoeSVyeh8ZCJKpN+NKH2rgvZq1rMrKjZ+YE7RpM8zw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
2011/12/10 Jaime Casanova <jaime(at)2ndquadrant(dot)com>:
> On Mon, Nov 28, 2011 at 1:32 PM, Julien Tachoires <julmon(at)gmail(dot)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,
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2011-12-12 15:55:35 | Re: review: CHECK FUNCTION statement |
Previous Message | Albe Laurenz | 2011-12-12 15:49:18 | Re: review: CHECK FUNCTION statement |