- get connection settings from command line:
./find.best.tablespace.split.pl “dbi:Pg:dbname=depesz;host=127.0.0.1;port=12345" depesz
- calculate only for public schema (can be easily changed)
- distribute indexes as well – always put indexes on another tablespace than table
- add comment in generated file about total filesizes in tablespaces *after* migration – so it will be clearer on what to move
svn is located here.