Horton

Re: patch : Allow toast tables to be moved to a different tablespace

Julien Tachoires <julmon@gmail.com>

View thread
From: Julien Tachoires <julmon@gmail.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>
Cc: Andreas Karlsson <andreas@proxel.se>, Alex Shulgin <ash@commandprompt.com>, Jaime Casanova <jaime@2ndquadrant.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2015-03-12T07:01:23Z
Lists: pgsql-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