Re: Tablespaces - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Tablespaces
Date
Msg-id 4045521E.8060106@familyhealth.com.au
Whole thread Raw
In response to Tablespaces  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: Tablespaces
List pgsql-hackers
> A table space parameter will be added to DDL commands which create
> physical database objects (CREATE DATABASE/INDEX/TABLE/SEQUENCE) and to
> CREATE SCHEMA. The associated routines, as well as the corresponding DROP
> commands will need to be updated. Adding the ability to ALTER <object>
> TABLESPACE <name> seems a little painful. Would people use it? Comments?

How about allowing the specification on schemas and databases of 
different default tablespaces for TEMP, TABLE and INDEX??  Is there any 
point to that?

Chris



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: API Layers within Postgres
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Tablespaces