Re: [PERFORM] Index files

2007-09-14 Thread Alan Hodgson
On Friday 14 September 2007, "Harsh Azad" <[EMAIL PROTECTED]> wrote: > Great, creating new tablespace for indexes worked! Now the question is > whether existing tables/index can be moved to the new tablespace using an > alter command or the only way possible is to drop and recreate them? > ALTER T

Re: [PERFORM] Index files

2007-09-14 Thread Mark Lewis
On Sat, 2007-09-15 at 01:51 +0530, Harsh Azad wrote: > Great, creating new tablespace for indexes worked! Now the question is > whether existing tables/index can be moved to the new tablespace using > an alter command or the only way possible is to drop and recreate > them? You can alter an existi

Re: [PERFORM] Index files

2007-09-14 Thread Harsh Azad
Great, creating new tablespace for indexes worked! Now the question is whether existing tables/index can be moved to the new tablespace using an alter command or the only way possible is to drop and recreate them? Azad On 9/14/07, Jean-David Beyer <[EMAIL PROTECTED]> wrote: > > Harsh Azad wrote:

Re: [PERFORM] Index files

2007-09-14 Thread Jean-David Beyer
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. > I am not an expert, but what I have done is put the Write-Ahead-Log on one hard drive, some little-used relations and their

Re: [PERFORM] Index files

2007-09-14 Thread Philippe Amelant
Le vendredi 14 septembre 2007 à 11:09 +0800, Ow Mun Heng a écrit : > On Fri, 2007-09-14 at 08:33 +0530, Harsh Azad wrote: > > 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 director

Re: [PERFORM] Index files

2007-09-13 Thread Tom Lane
"Harsh Azad" <[EMAIL PROTECTED]> 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

Re: [PERFORM] Index files

2007-09-13 Thread Ow Mun Heng
On Fri, 2007-09-14 at 08:33 +0530, Harsh Azad wrote: > 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 $PGDA

Re: [PERFORM] Index files

2007-09-13 Thread Harsh Azad
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 <[EMAIL PROTECTED]> wrote

Re: [PERFORM] Index files

2007-09-13 Thread Ow Mun Heng
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 tab

[PERFORM] Index files

2007-09-13 Thread Harsh Azad
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. Thanks, Azad