TODO? %Add default_index_tablespace GUC and database parameter. On Thu, Dec 01, 2005 at 11:48:28AM -0600, Kelly Burkhart wrote: > On 12/1/05, Alexander M. Pravking <fduch@xxxxxxxxxxxxxxxx> wrote: > > > > PostgreSQL 8.0 brought a great tablespaces feature. However, it's still > > a real pain for one who wants to separate tables and indices to different > > tablespaces: he has to do it manually, explicitely specifying tablespace > > for each index. > > > > Thus, I think it would be handy to have "default_index_tablespace" server > > variable. Any thoughts? > > > We would use such a thing. Our databases use three partitions: log, data, > index. We currently create our databases like: > > CREATE DATABASE dbname OWNER owner TABLESPACE tsname; > > We then specify another index tablespace on index creation (which really > isn't that difficult). > > > Adding an INDEX_TABLESPACE option to CREATE DATABASE might be worthwhile if > what we have done is typical. Or if pg maintainers want to suggest this > usage as sensible. > > -K -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
