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
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! |