Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 800139F9D9D for ; Thu, 13 Sep 2007 23:58:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 50154-07 for ; Thu, 13 Sep 2007 23:58:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from wdscexfe01.sc.wdc.com (wdscexfe01.sc.wdc.com [129.253.170.53]) by postgresql.org (Postfix) with ESMTP id 5F7F89F9D5D for ; Thu, 13 Sep 2007 23:58:37 -0300 (ADT) Received: from wdmyexbe03.my.asia.wdc.com ([129.253.105.55]) by wdscexfe01.sc.wdc.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 13 Sep 2007 19:58:23 -0700 Received: from 129.253.108.238 ([129.253.108.238]) by wdmyexbe03.my.asia.wdc.com ([129.253.105.55]) with Microsoft Exchange Server HTTP-DAV ; Fri, 14 Sep 2007 02:57:45 +0000 Received: from neuromancer by 129.253.105.55; 14 Sep 2007 10:57:24 +0800 Subject: Re: Index files From: Ow Mun Heng To: Harsh Azad Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Fri, 14 Sep 2007 10:57:24 +0800 Message-Id: <1189738644.22645.14.camel@neuromancer.home.net> Mime-Version: 1.0 X-Mailer: Evolution 2.10.2 X-OriginalArrivalTime: 14 Sep 2007 02:58:23.0809 (UTC) FILETIME=[1D67A310:01C7F67B] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.407 tagged_above=0 required=5 tests=AWL=-0.661, BAYES_50=0.001, RCVD_NUMERIC_HELO=2.067 X-Spam-Level: * X-Archive-Number: 200709/261 X-Sequence-Number: 26806 On Fri, 2007-09-14 at 08:20 +0530, Harsh Azad wrote: > Hi, > > Where are the database index files located in the $PGDATA directory? I > was thinking on soft linking them to another physical hard disk array. you have to search through pg_class for the "number" Alternatively, you can try using tablespaces. create tablespace indexspace location '/mnt/fastarray' create index newindex on table (index_1) tablespace indexspace