On Sat, 2007-09-15 at 01:51 +0530, Harsh Azad wrote: > Great, creating new tablespace for indexes worked! Now the question is > whether existing tables/index can be moved to the new tablespace using > an alter command or the only way possible is to drop and recreate > them?
You can alter an existing index: http://www.postgresql.org/docs/8.2/static/sql-alterindex.html ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
