From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
---|---|
To: | Julien Tachoires <julmon(at)gmail(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-10 21:16:08 |
Message-ID: | CAJKUy5itRAtv7A3y7nVKmKe8SZdTU5Q-OsPr4d3ySYqoHkzK1g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Nov 28, 2011 at 1:32 PM, Julien Tachoires <julmon(at)gmail(dot)com> wrote:
> Hi Jaime,
>
> Please find a new version.
>
cool
>> 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;
"""
>>
>> 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
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-12-11 01:26:40 | Re: static or dynamic libpgport |
Previous Message | Marti Raudsepp | 2011-12-10 19:05:08 | Re: [PATCH] Caching for stable expressions with constant arguments v3 |