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: > > 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 indices on a second hard > drive, and the main database files on four other drives. These are SCSI > hard > drives and I have two SCSI controllers. /dev/sda and /dev/sdb are on one > controller, and the other four hard drives are on the other controller. > These controllers are on a PCI-X bus all their own. > > I put $PGDATA (I do not actually set or use that global variable) on > /dev/sda. > > [/srv/dbms/dataA/pgsql/data]$ ls -l > total 88 > -rw------- 1 postgres postgres 4 Aug 11 13:32 PG_VERSION > drwx------ 5 postgres postgres 4096 Aug 11 13:32 base > drwx------ 2 postgres postgres 4096 Sep 14 09:16 global > drwx------ 2 postgres postgres 4096 Sep 13 23:35 pg_clog > -rw------- 1 postgres postgres 3396 Aug 11 13:32 pg_hba.conf > -rw------- 1 root root 3396 Aug 16 14:32 pg_hba.conf.dist > -rw------- 1 postgres postgres 1460 Aug 11 13:32 pg_ident.conf > drwx------ 4 postgres postgres 4096 Aug 11 13:32 pg_multixact > drwx------ 2 postgres postgres 4096 Sep 14 09:16 pg_subtrans > drwx------ 2 postgres postgres 4096 Aug 12 16:14 pg_tblspc > drwx------ 2 postgres postgres 4096 Aug 11 13:32 pg_twophase > drwx------ 3 postgres postgres 4096 Sep 14 09:13 pg_xlog > -rw------- 1 postgres postgres 15526 Sep 11 22:31 postgresql.conf > -rw------- 1 postgres postgres 13659 Aug 11 13:32 postgresql.conf.dist > -rw------- 1 postgres postgres 56 Sep 14 07:33 postmaster.opts > -rw------- 1 postgres postgres 52 Sep 14 07:33 postmaster.pid > > In /dev/sdb are > > ]$ ls -l > total 12 > drwxr-x--- 2 postgres postgres 4096 Aug 18 00:00 pg_log > -rw------- 1 postgres postgres 2132 Sep 14 07:25 pgstartup.log > drwx------ 3 postgres postgres 4096 Aug 12 21:06 stock > > The stuff in "stock" are little-used tables and their indices. > > Everything else is on the other four drives. I put the index for a table > on > a separate drive from the tata for the table. > > -- > .~. Jean-David Beyer Registered Linux User 85642. > /V\ PGP-Key: 9A2FC99A Registered Machine 241939. > /( )\ Shrewsbury, New Jersey http://counter.li.org > ^^-^^ 09:10:01 up 1:37, 4 users, load average: 5.77, 5.12, 4.58 > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate > -- Harsh Azad ======================= [EMAIL PROTECTED]
