Re: New tablespace: just an advice

2018-10-16 Thread Moreno Andreo
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 objec

Re: New tablespace: just an advice

2018-10-16 Thread Laurenz Albe
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 obj

New tablespace: just an advice

2018-10-15 Thread Moreno Andreo
Hi everyone! My space on my Debian 8 DB server is running a bit low (10% left of a 2TB disk), so, since it's not possible to have a primary MBR disk with size > 2 TB, I decided to create another disk and map it on the server, creating another tablespace on it and moving databases aross disks t