On Fri, Jan 31, 2014 at 1:24 PM, alexandros_e <alexandros.ef@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
