|
Home > Archive > PostgreSQL Administration > November 2006 > Move indexes
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Alexander Burbello 2006-11-13, 5:29 am |
| Hi,
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.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
| |
|
| Drop the index and recreate it in the new tablespace.
On 11/13/06, Alexander Burbello <burbello3000@yahoo.com.br> wrote:
>
> Hi,
>
> 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.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
| |
| Simon Riggs 2006-11-14, 7:19 pm |
| 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
|
|
|
|
|