Feature Request - Defining default table space for Indexes in Conf file

From: S Sharma <data_arch(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Feature Request - Defining default table space for Indexes in Conf file
Date: 2007-10-01 18:22:16
Message-ID: 169689.80382.qm@web54207.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

The default table space defined in db conf file is used for all database tables as well as indexes. So putting the indexes on another table space requires manually dropping and re-creating indexes.
It would be nice to have a feature to define a default table space for indexes in db conf file and all indexed are created in that table space. This would allow creating a good database architecture to avoid disc contention easily.

Thanks
Data_arch


---------------------------------
Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Goboxe 2007-10-01 18:26:20 Re: Partitioned table limitation
Previous Message Joshua D. Drake 2007-10-01 18:15:42 PostgreSQL Conference Fall 2007, final schedule