Re: Index files

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: Harsh Azad <harsh(dot)azad(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index files
Date: 2007-09-14 02:57:24
Message-ID: 1189738644.22645.14.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Harsh Azad 2007-09-14 03:03:12 Re: Index files
Previous Message Harsh Azad 2007-09-14 02:50:17 Index files