Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Index files
- From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Index files
- Date: Fri, 14 Sep 2007 13:29:01 -0700
On Friday 14 September 2007, "Harsh Azad" <harsh(dot)azad(at)gmail(dot)com> 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? > ALTER TABLE table_name set tablespace new_tablespace; and ALTER INDEX ... -- Eat right. Exercise regularly. Die anyway.
- 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 usage when bitwise operator is used
- Previous by thread: Re: Index files
- Next by thread: Re: When/if to Reindex
- Indexes: