Tablespaces and indexes

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: pgsql-general(at)postgresql(dot)org (pgsql general list)
Subject: Tablespaces and indexes
Date: 2005-03-28 01:46:41
Message-ID: 200503280146.j2S1kffd009978@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to move over 50 tables (several over 500MB each) from a 7.4.5
database to 8.0.1 on a regular basis during system testing. (The 8.0.1
system will become the production system soon, probably next month.)

I'd like to have the data table and its indexes built in separate tablespaces
on separate physical drives. The 'default tablespace' parameter appears
to apply equally to both the data table and any 'create index' commands.

Editing the .dmp files to insert a tablespace clause in the CREATE INDEX
commands in the .dmp file is impractical because of their size, any
suggestions how to automate this?

Related question: Once I switch the 8.0.1 system over to be the production,
can I reverse the direction and restore .dmp files on the 7.4.5 system or
are the tablespace terms in the dump files going to cause problems?

Eventually the 7.4.5 system will be upgraded to version 8, but that may not
happen for a couple of months.

Are there any plans to have a separate 'default index tablespace' parameter?
--
Mike Nolan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-03-28 01:51:05 Re: Debugging deadlocks
Previous Message Kyrill Alyoshin 2005-03-28 00:28:21 After Insert or Update Trigger Issues!