Skip site navigation (1) Skip section navigation (2)

Re: Move indexes

From: adey <adey11(at)gmail(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-13 23:35:25
Message-ID: 1c66bda80611131535n25b2a610gb9cb44a080b69f52@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Drop the index and recreate it in the new tablespace.

On 11/13/06, Alexander Burbello <burbello3000(at)yahoo(dot)com(dot)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
>

In response to

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

pgsql-admin by date

Next:From: adeyDate: 2006-11-13 23:40:32
Subject: Re: Issue with processes open for clients
Previous:From: TomDBDate: 2006-11-13 21:21:40
Subject: replication?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group