> > 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 > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]