Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 1E01A9F9BCB for ; Fri, 14 Sep 2007 00:33:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 14211-10 for ; Fri, 14 Sep 2007 00:33:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C03429F9B13 for ; Fri, 14 Sep 2007 00:33:25 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l8E3XNgK018990; Thu, 13 Sep 2007 23:33:23 -0400 (EDT) To: "Harsh Azad" cc: pgsql-performance@postgresql.org Subject: Re: Index files In-reply-to: References: Comments: In-reply-to "Harsh Azad" message dated "Fri, 14 Sep 2007 08:20:17 +0530" Date: Thu, 13 Sep 2007 23:33:23 -0400 Message-ID: <18989.1189740803@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/264 X-Sequence-Number: 26809 "Harsh Azad" writes: > Where are the database index files located in the $PGDATA directory? Read http://www.postgresql.org/docs/8.2/static/storage.html > I was > thinking on soft linking them to another physical hard disk array. Manual symlink management, while not impossible, pretty much sucks ... especially if your tables are big enough that you actually need to do this. Use a tablespace instead. (If you are on a PG version that hasn't got tablespaces, you are more than overdue to upgrade.) regards, tom lane