agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Julien Tachoires <julmon@gmail.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Andreas Karlsson <andreas@proxel.se>
Cc: Alex Shulgin <ash@commandprompt.com>
Cc: Jaime Casanova <jaime@2ndquadrant.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: patch : Allow toast tables to be moved to a different tablespace
Date: Thu, 12 Mar 2015 08:01:23 +0100
Message-ID: <550139C3.2040704@gmail.com> (raw)
In-Reply-To: <20150310122740.GZ3291@alvh.no-ip.org>
References: <CAFEQCbGEjp6j6-XD4C-vDaAyRHh6aMbH__BWB3kBuT505LXQyw@mail.gmail.com>
<CA+TgmoaJOK6yKMZw8sc5HzRD8hb0bzCV0U4JuNc3XdACmfQCYw@mail.gmail.com>
<CAFEQCbESRGXLE4+tRAnazr8QmBJzfYPwc6GP1Daq0quyuyEpZQ@mail.gmail.com>
<1323956011-sup-9589@alvh.no-ip.org>
<CAFEQCbEq07OopgE5xFYv2Q3eMq45hRSJkjCBO+kvpJq9NEVhow@mail.gmail.com>
<87r3wn5lhq.fsf@commandprompt.com>
<54A2127D.5020907@proxel.se>
<54F5CFDE.20301@gmail.com>
<54FE2C23.1080604@proxel.se>
<CA+TgmobETPtbU7oFcecnAuqL+C5-9eF2zpfDOVB+9J51rhbCLg@mail.gmail.com>
<20150310122740.GZ3291@alvh.no-ip.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
On 10/03/2015 13:27, Alvaro Herrera wrote:
> Robert Haas wrote:
>> On Mon, Mar 9, 2015 at 7:26 PM, Andreas Karlsson <andreas@proxel.se> wrote:
>
>>> I think we should allow moving the indexes for consistency. With this patch
>>> we can move everything except for TOAST indexes.
>>
>> It might make sense to always put the TOAST index with the TOAST
>> table, but it seems strange to put the TOAST index with the heap and
>> the TOAST table someplace else. Or at least, that's how it seems to
>> me.
>
> Agreed. It doesn't seem necessary to allow moving the toast index to a
> tablespace other than the one containing the toast table. In other
> words, if you move the toast table, the index always follows it, and
> there's no option to move it independently.
This behaviour is already implemented, the TOAST index always follows
the TOAST table. I'll add a couple of regression tests about it.
--
Julien
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
view thread (57+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: julmon@gmail.com, alvherre@2ndquadrant.com, robertmhaas@gmail.com, andreas@proxel.se, ash@commandprompt.com, jaime@2ndquadrant.com
Subject: Re: patch : Allow toast tables to be moved to a different tablespace
In-Reply-To: <550139C3.2040704@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox