Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5D7699FB377 for ; Fri, 14 Sep 2007 17:29:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 76073-05 for ; Fri, 14 Sep 2007 17:29:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from skynet.simkin.ca (skynet.simkin.ca [72.51.27.117]) by postgresql.org (Postfix) with ESMTP id A02F39FB30D for ; Fri, 14 Sep 2007 17:29:10 -0300 (ADT) Received: from charon.medialogik.com (charon.medialogik.com [72.51.27.114]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by skynet.simkin.ca (Postfix) with ESMTP id 3AF874006 for ; Fri, 14 Sep 2007 13:29:09 -0700 (PDT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: Index files Date: Fri, 14 Sep 2007 13:29:01 -0700 User-Agent: KMail/1.9.6 References: <46EA8B00.9030600@verizon.net> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200709141329.01171@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/280 X-Sequence-Number: 26825 On Friday 14 September 2007, "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? > ALTER TABLE table_name set tablespace new_tablespace; and ALTER INDEX ... -- Eat right. Exercise regularly. Die anyway.