Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 75C8D9F9E11 for ; Fri, 14 Sep 2007 00:03:28 -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 22573-01 for ; Fri, 14 Sep 2007 00:03:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.190]) by postgresql.org (Postfix) with ESMTP id B741A9F9E01 for ; Fri, 14 Sep 2007 00:03:14 -0300 (ADT) Received: by fk-out-0910.google.com with SMTP id b27so699941fka for ; Thu, 13 Sep 2007 20:03:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=thcLTEL91wYjEvkK4N0AGXLHIV5veCWy+ObgQEBaDlE=; b=Hupns08xTmmJX0qTvWEynrBlXouRrnw90KnwKWvLMEN/cage78ft3U4mSwit0GlV+1lOL7WJX2S97R4qJ2WKhdK7N9C3cVagodLd7bX3n1O+EDYt3UhzwmbmdhKyD+kkPfNKUO1rTcNGERJnl+Hf5ZSepJkT2cnHYFz1NskrpR4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=ehA+k7AEjxTiEse0i2/lbFZ9Zhj3UF6gj/XtCxwwIkGjKbxXLjf5tA2SY11V39ybbqR+/xo1Z05FxNkZjX3LN0dkpwFqFXk0OeuWJEMeGicvl0LLsQ0uT134dqLpNLcEtFg+mhavdZ7hiatnL8lRGmv9LoqJPiBmcykamLMW9bw= Received: by 10.82.189.6 with SMTP id m6mr679014buf.1189738992646; Thu, 13 Sep 2007 20:03:12 -0700 (PDT) Received: by 10.82.105.9 with HTTP; Thu, 13 Sep 2007 20:03:12 -0700 (PDT) Message-ID: Date: Fri, 14 Sep 2007 08:33:12 +0530 From: "Harsh Azad" To: "Ow Mun Heng" Subject: Re: Index files Cc: pgsql-performance@postgresql.org In-Reply-To: <1189738644.22645.14.camel@neuromancer.home.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_85_28075367.1189738992635" References: <1189738644.22645.14.camel@neuromancer.home.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/262 X-Sequence-Number: 26807 ------=_Part_85_28075367.1189738992635 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 Thanks On 9/14/07, Ow Mun Heng wrote: > > 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 > > -- Harsh Azad ======================= Harsh.Azad@gmail.com ------=_Part_85_28075367.1189738992635 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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

Thanks

On 9/14/07, Ow Mun Heng <Ow.Mun.Heng@wdc.com> wrote:
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




--
Harsh Azad
=======================
Harsh.Azad@gmail.com
------=_Part_85_28075367.1189738992635--