Re: [GENERAL] Reindexing and tablespaces

2014-01-31 Thread 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 -

Re: [GENERAL] Reindexing and tablespaces

2014-01-30 Thread Michael Paquier
On Fri, Jan 31, 2014 at 1:24 PM, alexandros_e 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 >

[GENERAL] Reindexing and tablespaces

2014-01-30 Thread 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