October 19th, 2007 by depesz | Tags: | Comments Off on find.best.tablespace.split.pl
Did it help? If yes - maybe you can help me?


  1. get connection settings from command line:
    ./find.best.tablespace.split.pl “dbi:Pg:dbname=depesz;host=;port=12345" depesz
  2. calculate only for public schema (can be easily changed)
  3. distribute indexes as well – always put indexes on another tablespace than table
  4. 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.

Sorry, comments for this post are disabled.