Postgres Pro
Downloads
Home   >   mailing lists

Feature Request - Defining default table space for Indexes in Conf file - Mailing list pgsql-general

From S Sharma
Subject Feature Request - Defining default table space for Indexes in Conf file
Date
Msg-id 169689.80382.qm@web54207.mail.re2.yahoo.com
Whole thread Raw
Responses Re: Feature Request - Defining default table space for Indexes in Conf file
Re: Feature Request - Defining default table space for Indexes in Conf file
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: MrKrinkle
Date:
Subject: Re: It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username
Next
From: "Scott Marlowe"
Date:
Subject: Re: It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username