Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B68729F97A5 for ; Fri, 14 Sep 2007 00:10:59 -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 25621-05 for ; Fri, 14 Sep 2007 00:10:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from wdscexfe02.sc.wdc.com (wdscexfe02.sc.wdc.com [129.253.170.52]) by postgresql.org (Postfix) with ESMTP id B2AAD9F9709 for ; Fri, 14 Sep 2007 00:10:53 -0300 (ADT) Received: from wdmyexbe03.my.asia.wdc.com ([129.253.105.55]) by wdscexfe02.sc.wdc.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 13 Sep 2007 20:10:40 -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 03:10:10 +0000 Received: from neuromancer by 129.253.105.55; 14 Sep 2007 11:09:49 +0800 Subject: Re: Index files From: Ow Mun Heng To: Harsh Azad Cc: pgsql-performance@postgresql.org In-Reply-To: References: <1189738644.22645.14.camel@neuromancer.home.net> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Fri, 14 Sep 2007 11:09:49 +0800 Message-Id: <1189739389.22645.24.camel@neuromancer.home.net> Mime-Version: 1.0 X-Mailer: Evolution 2.10.2 X-OriginalArrivalTime: 14 Sep 2007 03:10:40.0957 (UTC) FILETIME=[D4C77ED0:01C7F67C] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.413 tagged_above=0 required=5 tests=AWL=-0.655, BAYES_50=0.001, RCVD_NUMERIC_HELO=2.067 X-Spam-Level: * X-Archive-Number: 200709/263 X-Sequence-Number: 26808 On Fri, 2007-09-14 at 08:33 +0530, Harsh Azad wrote: > ah.. thanks. Didn't realize table spaces can be mentioned while > creating a index. BTW, are soft links ok to use for pg_clog / > pg_xlog . I moved the existing directories to /mnt/logs/pglogs and > made soft links for both directories in $PGDATA No idea what is the "proper" solution. Me being a newbie itself. But from what I've read on the net and google, symlink seems to be the order of the day. perhaps others who are more familiar can comment as I'm lost in this. (I'm doing symlinking btw)