Re: Move indexes

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Alexander Burbello" <burbello3000(at)yahoo(dot)com(dot)br>
Cc: "Lista Postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Move indexes
Date: 2006-11-14 21:48:20
Message-ID: 1163540901.27956.112.camel@silverbirch.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, 2006-11-13 at 08:17 -0200, Alexander Burbello wrote:

> I have one tablespace with all my objects.
> I would like to separate indexes from other.
>
> How can I select and move with SQL???
>
> Thank you for your help.

ALTER INDEX name SET TABLESPACE tablespace_name

is the approved way and quicker than re-creating the indexes.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

In response to

  • Move indexes at 2006-11-13 10:17:32 from Alexander Burbello

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2006-11-14 22:14:51 Re: Checkpoint Location Format
Previous Message TomDB 2006-11-14 21:10:53 Re: replication?