Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 14 Sep 2007 10:57:24 +0800
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
- Follow-Ups:
- Re: Index files
- From: Harsh Azad
- Re: Index files
- References:
- Index files
- From: Harsh Azad
- Index files
- Prev by Date: Index files
- Next by Date: Re: Index files
- Previous by thread: Index files
- Next by thread: Re: Index files
- Indexes: