Thread: moving toast table to its own tablespace
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@alvh.no-ip.org>
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. +