Re: Index files

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(dot)Mun(dot)Heng(at)wdc(dot)com> 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(dot)Azad(at)gmail(dot)com