From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Index files
Date: Fri, 14 Sep 2007 13:29:01 -0700
Message-ID: <200709141329.01171@hal.medialogik.com> (raw)
In-Reply-To: <a199704d0709141321h598e20ebn9b0a8039d79576f@mail.gmail.com>
References: <a199704d0709131950i3c23ea35wb0a19f393533197e@mail.gmail.com>
<46EA8B00.9030600@verizon.net>
<a199704d0709141321h598e20ebn9b0a8039d79576f@mail.gmail.com>
On Friday 14 September 2007, "Harsh Azad" <harsh.azad@gmail.com> wrote:
> Great, creating new tablespace for indexes worked! Now the question is
> whether existing tables/index can be moved to the new tablespace using an
> alter command or the only way possible is to drop and recreate them?
>
ALTER TABLE table_name set tablespace new_tablespace;
and ALTER INDEX ...
--
Eat right. Exercise regularly. Die anyway.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ahodgson@simkin.ca
Subject: Re: Index files
In-Reply-To: <200709141329.01171@hal.medialogik.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox