From: Harsh Azad <harsh.azad@gmail.com>
To: Ow Mun Heng <Ow.Mun.Heng@wdc.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Index files
Date: Fri, 14 Sep 2007 08:33:12 +0530
Message-ID: <a199704d0709132003l5e2bd0cweb3d045c038493bb@mail.gmail.com> (raw)
In-Reply-To: <1189738644.22645.14.camel@neuromancer.home.net>
References: <a199704d0709131950i3c23ea35wb0a19f393533197e@mail.gmail.com>
<1189738644.22645.14.camel@neuromancer.home.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: harsh.azad@gmail.com, Ow.Mun.Heng@wdc.com
Subject: Re: Index files
In-Reply-To: <a199704d0709132003l5e2bd0cweb3d045c038493bb@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox