Обсуждение: Reindexing and tablespaces

Поиск
Список
Период
Сортировка

Reindexing and tablespaces

От
alexandros_e
Дата:
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.

Re: Reindexing and tablespaces

От
Michael Paquier
Дата:
On Fri, Jan 31, 2014 at 1:24 PM, alexandros_e <alexandros.ef@gmail.com> wrote:
> 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;
They remain on the tablespace they have been created on. Note as well
that the new value of default_tablespace takes effect only after
reloading the session.
Regards,
--
Michael

Re: Reindexing and tablespaces

От
alexandros_e
Дата:
You were right. I just reindexed the DB and I saw no real changes in drive
storage (those tablespaces are on separate hard disk volumes). Thanks



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