Hi,
The 1.0.2 release of the PgToolkit is on the way. Some significant
improvements of the tables and indexes bloat reducing tool have been
made.
Testers are very welcome. Use this link to get the testing version
https://github.com/grayhemp/pgtoolkit/branches/v1.0testing
Report bugs and suggestions either to me directly or on the issue page
https://github.com/grayhemp/pgtoolkit/issues.
List of changes:
- 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
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979
gray.ru@gmail.com