Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 85F269FB25A for ; Tue, 14 Nov 2006 17:49:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 77980-06 for ; Tue, 14 Nov 2006 21:48:58 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id C70CF9FB232 for ; Tue, 14 Nov 2006 17:48:57 -0400 (AST) thread-index: AccINrCCz1m24U2CRgivolcn/525pw== Received: from [192.168.0.31] ([84.12.80.212]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 14 Nov 2006 16:48:57 -0500 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Content-class: urn:content-classes:message Importance: normal Subject: Re: Move indexes From: "Simon Riggs" To: "Alexander Burbello" Cc: "Lista Postgres" In-Reply-To: <4558463C.9070502@yahoo.com.br> References: <4558463C.9070502@yahoo.com.br> Content-Type: text/plain; charset="iso-8859-1" Date: Tue, 14 Nov 2006 21:48:20 +0000 Message-ID: <1163540901.27956.112.camel@silverbirch.site> MIME-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 14 Nov 2006 21:48:58.0078 (UTC) FILETIME=[B033A7E0:01C70836] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/149 X-Sequence-Number: 23676 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