Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 14 Sep 2007 13:25:51 -0700
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
- References:
- Index files
- From: Harsh Azad
- Re: Index files
- From: Jean-David Beyer
- Re: Index files
- From: Harsh Azad
- Index files
- Prev by Date: Re: Index files
- Next by Date: Re: Index files
- Previous by thread: Re: Index files
- Next by thread: Re: Index files
- Indexes: