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