Re: Massive table bloat - Mailing list pgsql-admin

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 <ruralhunter@gmail.com> wrote:
> 于 2012/12/12 13:44, Sergey Konoplev 写道:
>
>> On Tue, Dec 11, 2012 at 9:39 PM, Rural Hunter <ruralhunter@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.ru@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.ru@gmail.com