| 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: | Whole Thread | Raw Message | 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 |