pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Mark Lewis <mark.lewis@mir3.com>
To: Harsh Azad <harsh.azad@gmail.com>
Cc: Jean-David Beyer <jeandavid8@verizon.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Index files
Date: Fri, 14 Sep 2007 13:25:51 -0700
Message-ID: <1189801551.11507.214.camel@archimedes> (raw)
In-Reply-To: <a199704d0709141321h598e20ebn9b0a8039d79576f@mail.gmail.com>
References: <a199704d0709131950i3c23ea35wb0a19f393533197e@mail.gmail.com>
	<46EA8B00.9030600@verizon.net>
	<a199704d0709141321h598e20ebn9b0a8039d79576f@mail.gmail.com>

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

view thread (10+ messages)  latest in thread

Message-ID: <1189801551.11507.214.camel@archimedes>
Permalink:  ../1189801551.11507.214.camel@archimedes/
Also on:    postgresql.org/message-id/1189801551.11507.214.camel@archimedes

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: mark.lewis@mir3.com, harsh.azad@gmail.com, jeandavid8@verizon.net
  Subject: Re: Index files
  In-Reply-To: <1189801551.11507.214.camel@archimedes>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox