CHANGES.md

PgToolkit - tools for PostgreSQL maintenance

Changes

- PgToolkit v1.0.3

• Fixed the quotation bug for indexes with names containing whitespaces (thanks to Rafał Fitt)

2014-02-22 - PgToolkit v1.0.2

• Fixed the non working statement timeout in the reindexing process
• Made it use DROP INDEX CONCURRENTLY if version is >=9.2
• Fixed the randomness of the SET statements order in database adapters
• Made it to process TOAST tables and indexes providing bloat information and rebuilding instructions
• Set an additional protection against the "incorrect result of cleaning" error

2014-02-07 - PgToolkit v1.0.1

• Fixed the dependency check leading to the inability to re-index some primary keys
• Turned off statement timeouts for pgcompact's sessions
• Increased the psql response timeout to 10 hours
• Removed the necessity to set PERL5LIB (thanks to Hubert "depesz" Lubaczewski)
• Fixed the completion check leading to unfinished processing in some cases
• Made the re-indexation process more lock-friendly by getting rid of long waiting for exclusive locks
• Added usage examples to the --help output
• Got rid of hard-coded connection parameters (thanks to Hubert "depesz" Lubaczewski)
• Allowed processing of the postgres and template1 databases
• Resolved the several simultaneously running instances collisions issue (thanks to Gonzalo Gil)

2013-10-01 - PgToolkit v1.0.0

Note that pgcompactor was renamed to pgcompact.

• Set lc_messages to C to simplify message processing
• Renamed pgcompactor to pgcompact
• Fixed the lc_messages invalid value issue
• Reviewed documentation and licensing info
• Added a short list of pgcompact's abilities
• Fixed the $prog_name in concatenation error
• Added an experimental feature of compacting system catalog
• Excluded pg_catalog.pg_index from compacting list
• Fixed wrong initial index size reporting after reindexing
• Fixed psql error trapping and adjusted error reporting
• Improved the error processing in database adapters
• Reviewed the pgcompact's man
• Adapted to comply with GitHub
• Added future plans

2013-02-01 - PgToolkit 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 Rural Hunter).
• Made it use .pgpass and environment variables (thanks to Rural Hunter)
• 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).

2012-04-09 - PgToolkit v1.0beta3

• Added reindexing when table is skipped and pgstattuple installed
• Fixed wrong fillfactor calculation for tables and indexes
• Added the minimum pages restriction for indexes
• Added a check of base restrictions after processing
• Added a session_replication_role check in the cleaning function
• Made reindexing of non btree indexes only when --force is specified
• Refactored the index dependencies check to not rebuild indexes that require heavy locks
• Solved the psql adapter quietness problem (thanks to e.sergey for the bug report).

2012-02-21 - PgToolkit v1.0beta2

• Fixed the error when -d and/or -t are specified
• Fixed the bug with conforming strings
• Fixed the unicode name index altering bug
• Fixed the error output recognition in the psql adapter
• Prevented processing from interupting after deadlocks
• Fixed the "can not get bloat statistics" warning on empty tables
• Disabled printing incomplete statistics if table is processed
• Set synchronous_commit to off and session_replication_role to replica on the database level.

2012-02-02 - PgToolkit v1.0beta1

Take into consideration the new name of the tool.

• Renamed pg_compactor tool to pgcompactor
• Added --dry-run
• Added fillfactor to all the statistics calculations
• Fixed the reindex duration bug
• Got rid of the schema as a middle level
• Tables are sorted by size inside their database
• Added the ability of reindexing internal indexes like PRIMARY KEY and UNIQUE
• Added the reindexing necessity check based on the pgstattuple statistics
• A lot of minor changes.

2012-01-11 - PgToolkit v1.0alpha7

• Reworked reindex to be performed in any case when a table has been compacted or it has not (after the last iteration)
• Fixed the query for testing "always" and "replica" triggers
• Refactored the logic of bloat statistics to lower the amount of heavy pgstattuple calls
• Fixed the final statistics
• Added bloat statistics requests duration.

2012-01-06 - PgToolkit v1.0alpha6

• Refactored out useless resource consuming pgstattuple calls
• Added DEBUG0 and DEBUG1 logging levels and applied to SQL queries logging
• Turned off server side prepares for DBI drivers
• Made some minor changes.

2011-11-02 - PgToolkit v1.0alpha5

2011-10-26 - PgToolkit v1.0alpha4

2011-10-12 - PgToolkit v1.0alpha3

2011-10-11 - PgToolkit v1.0alpha2

2011-08-11 - PgToolkit v1.0alpha1