Releases: Alain-L/qwash
Releases · Alain-L/qwash
v0.4.0
Changelog
- 0732149 Docs: Add standalone btree_bloat.sql estimation query
- 84e0932 Docs: Align btree_bloat.sql header with table_bloat.sql
- 0969c8a Docs: Document --btree flag in README
- 92cc296 Docs: Prepare v0.4.0 release notes
- 5a6a284 Feat: Add --btree flag and index bloat output
- 33a1001 Feat: Add B-Tree index bloat estimation
- 69c5c4d Feat: B-Tree index bloat estimation (#2)
- 432b3a2 Fix: Remove FF column from index bloat summary
- 39419ea Merge pull request #2 from Alain-L/dev
- f31c6e5 Test: Add B-Tree index bloat integration tests
v0.3.0
Changelog
- ccdd6a6 Add .gitignore for Go project
- 900e4d2 Add comprehensive SQL documentation for debloat algorithm
- 1f477d2 Add integration tests for --reindex and SSL modes
- ab3c7f0 Add integration tests, golden files, and improve JSON output
- c63c82e CI: Build binary before running tests
- 4d14c8e CI: Upgrade to PostgreSQL 17
- 618a3bd Cleanup: consolidate SQL docs, remove obsolete files
- b6847cc Docs: Add LICENSE and update CONTRIBUTING.md for qwash
- c13aacb Docs: Add binary/package installation instructions, highlight qwash in comparison
- d5f3cdb Docs: Add pg_squeeze to alternatives comparison table
- af34ac2 Docs: Add pgstattuple dependency in comparison table
- a12d5b3 Docs: Clarify Trigger & FK safe uses session_replication_role
- 9e0c1ff Docs: Clarify bloat estimation query origin and link to source
- dc1177e Docs: Document TOAST bloat estimation in README
- fb01a9f Docs: Fix FSM misconception in TOAST bloat research
- 16941e0 Docs: Fix footnotes formatting in comparison table
- 5ef6d3f Docs: Fix installation URLs with version in filename
- 91d0264 Docs: Improve README with detailed feature comparison
- 5eacb09 Docs: Improve comparison table with explicit dependencies
- c98ccd7 Docs: Remove sql/README.md
- 412f5a6 Docs: Replace ppc/ppc_ref with min_pages_required in standalone SQL
- 40bd33d Docs: Rewrite standalone toast_bloat.sql without helper function
- d59122e Docs: Update README for v0.3.0 release
- 8f0e438 Docs: Update project documentation for TOAST bloat feature
- e3c315f Feat: Add TOAST bloat estimation
- 0ec510c Feat: Add TOAST bloat to JSON output
- e5471ee Feat: Add parallel table processing with LPT scheduling
- 32647c9 Feat: Add verbose mode, improve output styling, and validate --delay flag
- dba8eac Feature: Add --update --fast mode and implement rounds for --update
- 8e21723 Feature: Add CI/CD pipeline, versioning, and prepare for release
- 9f9b08c Feature: Add UPDATE-based compaction mode (--update flag)
- fba14d0 Feature: Add safety checks before compaction
- e044104 Fix: Add tolerance for non-deterministic PostgreSQL page management
- 575cd27 Fix: Clean up README output examples and JSON indexes:null
- ba499d1 Fix: Correct chunk sampling for 2-chunk TOAST values
- 536997e Fix: Improve TOAST bloat estimation robustness
- 4ae52ec Fix: Make golden test comparison order-independent for parallel execution
- 70e2f3a Fix: Remove legacy benchmark test file
- 83db194 Fix: Remove project docs from version control
- 19e9dda Fix: Remove research notes from version control
- 2cd4195 Fix: Update GitHub owner to Alain-L in all URLs
- 5d61270 Fix: Update golden file with correct test values
- d3fbd57 Fix: Update goreleaser config to version 2
- 30b4731 Fix: Use aligned payloads in TOAST tests for accurate estimation
- e3a0387 Fix: Use average chunk size for TOAST bloat estimation
- 0902635 Fix: Use correct GitHub owner in goreleaser
- cb6f80f Fix: Use full avg scan for TOAST chunk size estimation
- 6d1315d Fix: Use goreleaser v2 in release workflow
- 1ddf930 Fix: Use pg_column_size() in standalone TOAST bloat estimation
- 4a7d7e2 Implement functional --estimate and --debloat modes
- eb78913 Improve bloat report output formatting
- 59398e0 Improve comparison table in README: all Yes for qwash
- 1954f87 Initial commit with project structure and core functionality
- 9feb83b Merge pull request #1 from Alain-L/dev
- 183fd30 Minor: clarify vacuum threshold comments
- 6c455dd Move POC.sql to sql/, remove testdata from tracking
- f0fe625 Optimize debloat performance with improved iteration strategy
- 8ea2e16 Optimize qwash algorithm to achieve 99-100% VACUUM FULL efficiency
- 1e58baa README: Add 'What is Bloat?' section explaining bloat vs dead tuples
- 01dff0d README: Clarify ioguix reference is about the approach
- 9836e37 README: Fix output examples, comparison table, add references
- 6f2d39c Refactor: Adopt CTE structure for table_bloat.sql
- 3185589 Refactor: Make UPDATE method default, move DELETE/INSERT to --legacy
- eedc61f Refactor: Remove legacy DELETE/INSERT code, keep only UPDATE method
- 55f4bc5 Refactor: Simplify UPDATE mode with passes-based configuration
- 8533a0f Refactor: Switch to SQL templating for transparency
- ef938aa Refactor: Use array sorting for idempotent golden test comparison
- c12cb91 Refactor: extract debloat types and output to dedicated packages
- 78d77b0 Remove _archi.sh from repository
- a093e71 Remove build artifacts and profiling files from git tracking
- b34a387 Remove pgcompacttable binaries from repository
- 2f4bd59 Remove retroengineering directory from repository
- 4f644d5 Test: Add TOAST bloat estimation integration tests
- a5c7552 Tune thresholds to achieve 100% VACUUM FULL efficiency
- 26144e5 Update README with accurate documentation and examples
v0.2.0
Changelog
- ccdd6a6 Add .gitignore for Go project
- 900e4d2 Add comprehensive SQL documentation for debloat algorithm
- 1f477d2 Add integration tests for --reindex and SSL modes
- ab3c7f0 Add integration tests, golden files, and improve JSON output
- c63c82e CI: Build binary before running tests
- 4d14c8e CI: Upgrade to PostgreSQL 17
- 618a3bd Cleanup: consolidate SQL docs, remove obsolete files
- b6847cc Docs: Add LICENSE and update CONTRIBUTING.md for qwash
- c13aacb Docs: Add binary/package installation instructions, highlight qwash in comparison
- af34ac2 Docs: Add pgstattuple dependency in comparison table
- a12d5b3 Docs: Clarify Trigger & FK safe uses session_replication_role
- 9e0c1ff Docs: Clarify bloat estimation query origin and link to source
- 5ef6d3f Docs: Fix installation URLs with version in filename
- 91d0264 Docs: Improve README with detailed feature comparison
- 5eacb09 Docs: Improve comparison table with explicit dependencies
- c98ccd7 Docs: Remove sql/README.md
- e5471ee Feat: Add parallel table processing with LPT scheduling
- 32647c9 Feat: Add verbose mode, improve output styling, and validate --delay flag
- dba8eac Feature: Add --update --fast mode and implement rounds for --update
- 8e21723 Feature: Add CI/CD pipeline, versioning, and prepare for release
- 9f9b08c Feature: Add UPDATE-based compaction mode (--update flag)
- fba14d0 Feature: Add safety checks before compaction
- e044104 Fix: Add tolerance for non-deterministic PostgreSQL page management
- 4ae52ec Fix: Make golden test comparison order-independent for parallel execution
- 70e2f3a Fix: Remove legacy benchmark test file
- cc8d4df Fix: Replace dalibo with Alain-L in all URLs
- 5d61270 Fix: Update golden file with correct test values
- d3fbd57 Fix: Update goreleaser config to version 2
- 0902635 Fix: Use correct GitHub owner in goreleaser
- 6d1315d Fix: Use goreleaser v2 in release workflow
- 4a7d7e2 Implement functional --estimate and --debloat modes
- eb78913 Improve bloat report output formatting
- 59398e0 Improve comparison table in README: all Yes for qwash
- 1954f87 Initial commit with project structure and core functionality
- 183fd30 Minor: clarify vacuum threshold comments
- 6c455dd Move POC.sql to sql/, remove testdata from tracking
- f0fe625 Optimize debloat performance with improved iteration strategy
- 8ea2e16 Optimize qwash algorithm to achieve 99-100% VACUUM FULL efficiency
- 1e58baa README: Add 'What is Bloat?' section explaining bloat vs dead tuples
- 01dff0d README: Clarify ioguix reference is about the approach
- 9836e37 README: Fix output examples, comparison table, add references
- 6f2d39c Refactor: Adopt CTE structure for table_bloat.sql
- 3185589 Refactor: Make UPDATE method default, move DELETE/INSERT to --legacy
- eedc61f Refactor: Remove legacy DELETE/INSERT code, keep only UPDATE method
- 55f4bc5 Refactor: Simplify UPDATE mode with passes-based configuration
- 8533a0f Refactor: Switch to SQL templating for transparency
- ef938aa Refactor: Use array sorting for idempotent golden test comparison
- c12cb91 Refactor: extract debloat types and output to dedicated packages
- 78d77b0 Remove _archi.sh from repository
- a093e71 Remove build artifacts and profiling files from git tracking
- b34a387 Remove pgcompacttable binaries from repository
- 2f4bd59 Remove retroengineering directory from repository
- a5c7552 Tune thresholds to achieve 100% VACUUM FULL efficiency
- 26144e5 Update README with accurate documentation and examples