Re: [PATCHES] ALTER TABLE ... SET TABLESPACE

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
>

In response to

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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