| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | adey | 2006-11-13 23:40:32 | Re: Issue with processes open for clients |
| Previous Message | TomDB | 2006-11-13 21:21:40 | replication? |