Hi all, For those who are interested in pgcompactor - v1.0rc1 is out.
It contains a lot of improvements and has already been tested on a plenty of databases. The list of changes is below: 2013-02-01 v1.0rc1 - Refactored information files, PgToolkit is released under the PostgreSQL License now - Improved error messages, help hints and options' warnings - Added -V (--version) functionality - Fixed the bug with storage parameters on tables and indexes - Removed useless information from compacting results - Added bloat information to the messages about reindex impossibility - Made sizes pretty printed (kB, MB, GB, TB) - Moved skipping messages to the INFO level - Fixed the infinity loop on the size change check bug - Fixed the bug when reindex is skipped if table was not compacted but will be skipped the next round - Fixed the bug of reindexing when --dry-run is specified - Optimized the pgstattuple based bloat calculation - Refactored autonomous scripts building facilities, now the scripts are available straight from the fatpack/ directory - Fixed the error when 0 or 1 pages left - Fix the silent --man and --help problem - Separated completion statistics and warnings - Added a basic processing of the cases with tables/indexes deletion in the process of compacting - Fixed the reindex syntax and added a comment with database name - Fixed the partial indexes reindexing - Increased verbosity on connection errors (thanks to ruralhunter) - Made it use .pgpass and environment variables (thanks to ruralhunter) - Refactored the psql adapter to bidirectional communication what increased processing speed dramatically - Got rid of the final exception in the cleaning stored function (thanks to Lonni Friedman) On Wed, Dec 12, 2012 at 5:44 AM, Rural Hunter <ruralhun...@gmail.com> wrote: > δΊ 2012/12/12 13:44, Sergey Konoplev ει: > >> On Tue, Dec 11, 2012 at 9:39 PM, Rural Hunter <ruralhun...@gmail.com> >> wrote: >>> >>> Great. It works now. Thanks a lot for your instant help! >> >> You are welcome. >> >> Thanks for your feedback and sorry for this bugs. I have noted down >> this issue with password and planned to add .pg* and env support. > > No problem at all and thanks for the wonderful tool! > >> >> -- >> Sergey Konoplev >> Database and Software Architect >> http://www.linkedin.com/in/grayhemp >> >> Phones: >> USA +1 415 867 9984 >> Russia, Moscow +7 901 903 0499 >> Russia, Krasnodar +7 988 888 1979 >> >> Skype: gray-hemp >> Jabber: gray...@gmail.com >> > -- Sergey Konoplev Database and Software Architect http://www.linkedin.com/in/grayhemp Phones: USA +1 415 867 9984 Russia, Moscow +7 901 903 0499 Russia, Krasnodar +7 988 888 1979 Skype: gray-hemp Jabber: gray...@gmail.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin