| Lists: | pgsql-hackers |
|---|
| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | moving toast table to its own tablespace |
| Date: | 2011-05-19 19:17:12 |
| Message-ID: | 1305832478-sup-2082@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Is there a reason we don't allow moving the toast table to a separate
tablespace, other than unimplemented feature? If not, I propose such a
syntax as
ALTER TABLE foo SET TOAST TABLESPACE bar;
--
Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: moving toast table to its own tablespace |
| Date: | 2011-05-19 19:53:39 |
| Message-ID: | BANLkTikUihTXG=ZztkBkzr1ZBck7+Dj09g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Thu, May 19, 2011 at 3:17 PM, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
> Is there a reason we don't allow moving the toast table to a separate
> tablespace, other than unimplemented feature? If not, I propose such a
> syntax as
>
> ALTER TABLE foo SET TOAST TABLESPACE bar;
Off the top of my head, I don't see any reason not to allow that.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: moving toast table to its own tablespace |
| Date: | 2011-05-24 14:57:47 |
| Message-ID: | 201105241457.p4OEvlj04906@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Robert Haas wrote:
> On Thu, May 19, 2011 at 3:17 PM, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
> > Is there a reason we don't allow moving the toast table to a separate
> > tablespace, other than unimplemented feature? ?If not, I propose such a
> > syntax as
> >
> > ALTER TABLE foo SET TOAST TABLESPACE bar;
>
> Off the top of my head, I don't see any reason not to allow that.
Added to TODO:
Allow toast tables to be moved to a different tablespace
* http://archives.postgresql.org/pgsql-hackers/2011-05/msg00980.php
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +