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

From Tatsuo Ishii
Subject Re: [PATCHES] ALTER TABLE ... SET TABLESPACE
Date
Msg-id 20040621.081503.78706210.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: [PATCHES] ALTER TABLE ... SET TABLESPACE  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: [PATCHES] ALTER TABLE ... SET TABLESPACE
List pgsql-hackers
> > 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).
> 
> gavin
> 


pgsql-hackers by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: [PATCHES] ALTER TABLE ... SET TABLESPACE
Next
From: "Scott Marlowe"
Date:
Subject: Re: [PATCHES] ALTER TABLE ... SET TABLESPACE