Re: [PATCHES] ALTER TABLE ... SET TABLESPACE - Mailing list pgsql-hackers

From Scott Marlowe
Subject Re: [PATCHES] ALTER TABLE ... SET TABLESPACE
Date
Msg-id 1087778115.1187.3.camel@localhost.localdomain
Whole thread Raw
In response to Re: [PATCHES] ALTER TABLE ... SET TABLESPACE  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
On Sun, 2004-06-20 at 17:15, Tatsuo Ishii wrote:
> > > Also I think we need to enhance ALTER INDEX to assign new table spaces
> > > for indexes. Assigning different tables spaces for tables and indexes
> > > are essential to gain more I/O speed IMO.
> > 
> > I thought about this. ALTER INDEX doesn't exist yet and I figured that,
> > unlike the case of tables, its easy to drop and recreate indexes in new
> > tablespaces.
> 
> Oh you are right. I forgot about CREATE INDEX ... TABLESPACE.
> 
> > I'm still stumped as to where I am corrupting memory with this patch
> > though. (There was another bug: I wasn't detecting the case where users
> > set tablespace to the tablespace that the table is already in).

On a related note, will there be a way to have implicit index creation
occur in a seperate table space automagically?  I.e.

create table test (id int4 primary key, n1 int unique);

so that the indexes created in id and n1 here would have a different
default namespace than the table?  Just wondering.



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [PATCHES] ALTER TABLE ... SET TABLESPACE
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] ALTER TABLE ... SET TABLESPACE