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-13 03:28:05 |
Message-ID: | CAJKUy5gYJPR0ETVQQvSf2-mDfdsJU-7XSUVDFN_o4+ZaZtyATg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Dec 12, 2011 at 10:54 AM, Julien Tachoires <julmon(at)gmail(dot)com> wrote:
> 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 ?
>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2011-12-13 03:42:24 | Re: JSON for PG 9.2 |
Previous Message | Andrew Dunstan | 2011-12-13 03:08:28 | Re: JSON for PG 9.2 |