From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | swm(at)linuxworld(dot)com(dot)au |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [PATCHES] ALTER TABLE ... SET TABLESPACE |
Date: | 2004-06-20 23:15:03 |
Message-ID: | 20040621.081503.78706210.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
> > 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-06-21 00:17:35 | Re: nested xacts and phantom Xids |
Previous Message | Gavin Sherry | 2004-06-20 22:50:28 | Re: [PATCHES] ALTER TABLE ... SET TABLESPACE |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-06-21 00:17:35 | Re: nested xacts and phantom Xids |
Previous Message | Gavin Sherry | 2004-06-20 22:50:28 | Re: [PATCHES] ALTER TABLE ... SET TABLESPACE |