Reindexing and tablespaces

From: alexandros_e <alexandros(dot)ef(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Reindexing and tablespaces
Date: 2014-01-31 04:24:35
Message-ID: 1391142275321-5789827.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello to all,

I have done ALTER DATABASE "[database_name]" SET default_tablespace =
[new_tablespace]; I am wondering, if I reindex this entire DB would the
indexes automatically moved into the [new_tablespace] or will they remain in
the tablespace they were originally created on;

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Reindexing-and-tablespaces-tp5789827.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2014-01-31 04:49:43 Re: Reindexing and tablespaces
Previous Message Anand Kumar, Karthik 2014-01-31 01:03:18 Re: timezone change after upgrade from postgres 9.1 to 9.3?