Re: moving toast table to its own tablespace - Mailing list pgsql-hackers

From Robert Haas
Subject Re: moving toast table to its own tablespace
Date
Msg-id BANLkTikUihTXG=ZztkBkzr1ZBck7+Dj09g@mail.gmail.com
Whole thread Raw
In response to moving toast table to its own tablespace  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: moving toast table to its own tablespace  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Thu, May 19, 2011 at 3:17 PM, Alvaro Herrera <alvherre@alvh.no-ip.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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: switch UNLOGGED to LOGGED
Next
From: Peter Eisentraut
Date:
Subject: asterisk (non)expansion in GROUP BY clause