Re: Index files

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Harsh Azad <harsh(dot)azad(at)gmail(dot)com>
Cc: Jean-David Beyer <jeandavid8(at)verizon(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Index files
Date: 2007-09-14 20:25:51
Message-ID: 1189801551.11507.214.camel@archimedes
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alan Hodgson 2007-09-14 20:29:01 Re: Index files
Previous Message Harsh Azad 2007-09-14 20:21:06 Re: Index files