moving toast table to its own tablespace

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

Robert Haas wrote:

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.

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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +