Re: Index files - Mailing list pgsql-performance

From Tom Lane
Subject Re: Index files
Date
Msg-id 18989.1189740803@sss.pgh.pa.us
Whole thread Raw
In response to Index files  ("Harsh Azad" <harsh.azad@gmail.com>)
List pgsql-performance
"Harsh Azad" <harsh.azad@gmail.com> writes:
> Where are the database index files located in the $PGDATA directory?

Read
http://www.postgresql.org/docs/8.2/static/storage.html

> I was
> thinking on soft linking them to another physical hard disk array.

Manual symlink management, while not impossible, pretty much sucks
... especially if your tables are big enough that you actually need to
do this.  Use a tablespace instead.  (If you are on a PG version that
hasn't got tablespaces, you are more than overdue to upgrade.)

            regards, tom lane

pgsql-performance by date:

Previous
From: Ow Mun Heng
Date:
Subject: Re: Index files
Next
From: Bruce Momjian
Date:
Subject: Re: When/if to Reindex