Re: moving toast table to its own tablespace

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
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2011-05-19 20:08:33 asterisk (non)expansion in GROUP BY clause
Previous Message Robert Haas 2011-05-19 19:53:12 Re: switch UNLOGGED to LOGGED