Re: Index files

["Harsh Azad" <harsh.azad@xxxxxxxxx>]

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@xxxxxxx> 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@xxxxxxxxx