Il 16/10/2018 10:18, Laurenz Albe ha scritto:
Moreno Andreo wrote:
Now, 2 questions.
1. Is it all or do I need to adjust something else about permissions,
indexes, vacuuming, etc...?
ALTERing the database namespace means copying its physical files to new
directory, but is it applied to all objects (indexes, triggers, etc)?
All objects that are located in the default tablespace of the database
will be moved.
2. What will happen to who tries to access the database while it's being
moved from one tablespace to another?
They will be "hanging" with a lock until the transaction is done.
Yours,
Laurenz Albe
Perfect!
Thanks for your time,
Moreno
