Postgres Pro
Downloads
Home   >   mailing lists

Re: Tablespace issues (comment on ,moving indexes) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Tablespace issues (comment on ,moving indexes)
Date
Msg-id 19524.1092083762@sss.pgh.pa.us
Whole thread Raw
In response to Tablespace issues (comment on ,moving indexes)  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Responses Re: Tablespace issues (comment on ,moving indexes)  (Kevin Brown <kevin@sysexperts.com>)
Re: Tablespace issues (comment on ,moving indexes)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> 1. there is no COMMENT ON TABLESPACE support

That's right.

> 2. how is one supposed to move indexes(not tables) to another tablespace?

Use ALTER TABLE on the index.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Hicham G. Elmongui"
Date:
Subject: am i asking in the wrong place?
Next
From: Tom Lane
Date:
Subject: Re: fsync vs open_sync