| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Andreas Karlsson <andreas(at)proxel(dot)se>, Julien Tachoires <julmon(at)gmail(dot)com>, Alex Shulgin <ash(at)commandprompt(dot)com>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: patch : Allow toast tables to be moved to a different tablespace |
| Date: | 2015-03-10 12:27:40 |
| Message-ID: | 20150310122740.GZ3291@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Robert Haas wrote:
> On Mon, Mar 9, 2015 at 7:26 PM, Andreas Karlsson <andreas(at)proxel(dot)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.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2015-03-10 12:32:24 | Re: Performance improvement for joins where outer side is unique |
| Previous Message | Robert Haas | 2015-03-10 12:23:11 | Re: patch : Allow toast tables to be moved to a different tablespace |