Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9A0B99F9972 for ; Fri, 14 Sep 2007 17:26:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 87776-04 for ; Fri, 14 Sep 2007 17:25:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mir3-fs.mir3.com (mail.mir3.com [65.208.188.100]) by postgresql.org (Postfix) with ESMTP id 2B8EC9F9538 for ; Fri, 14 Sep 2007 17:25:54 -0300 (ADT) Received: MIR3-FS.mir3.com 172.16.1.11 from 172.16.2.68 172.16.2.68 via HTTP with MS-WebStorage 6.0.6249 Received: from archimedes by MIR3-FS.mir3.com; 14 Sep 2007 13:25:52 -0700 Subject: Re: Index files From: Mark Lewis To: Harsh Azad Cc: Jean-David Beyer , pgsql-performance@postgresql.org In-Reply-To: References: <46EA8B00.9030600@verizon.net> Content-Type: text/plain Content-Transfer-Encoding: 7bit Organization: MIR3, Inc. Date: Fri, 14 Sep 2007 13:25:51 -0700 Message-Id: <1189801551.11507.214.camel@archimedes> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/279 X-Sequence-Number: 26824 On Sat, 2007-09-15 at 01:51 +0530, Harsh Azad wrote: > Great, creating new tablespace for indexes worked! Now the question is > whether existing tables/index can be moved to the new tablespace using > an alter command or the only way possible is to drop and recreate > them? You can alter an existing index: http://www.postgresql.org/docs/8.2/static/sql-alterindex.html