Releases: mfvanek/pg-index-health-sql
Releases · mfvanek/pg-index-health-sql
v.0.30.0
v.0.20.3
What's Changed
- Bump super-linter/super-linter from 7.4.0 to 8.0.0 by @dependabot[bot] in #99
- Bump actions/checkout from 4 to 5 by @dependabot[bot] in #100
- Bump super-linter/super-linter from 8.0.0 to 8.1.0 by @dependabot[bot] in #101
- Add a new check "prefer timestamptz instead of timestamp" by @mfvanek in #102
- Add a new check for tables where the primary key columns are not first by @mfvanek in #103
- Add a new check "Tables that have all columns besides the primary key that are nullable" by @mfvanek in #104
Full Changelog: v.0.20.2...v.0.20.3
v.0.20.2
v.0.20.1
v.0.15.0
What's Changed
- Bump super-linter/super-linter from 7.3.0 to 7.4.0 by @dependabot in #92
- Primary keys that most likely natural keys by @mfvanek in #93
Full Changelog: v.0.14.6...v.0.15.0
v.0.14.6
What's Changed
- Add a check to find tables with zero or one column by @mfvanek in #80
- Add description to a new check by @mfvanek in #81
- Add a check to find object names that do not follow naming convention by @mfvanek in #82
- Add another link by @mfvanek in #83
- [not_valid_constraints] Add test with badly named constraints by @mfvanek in #84
- Add a check to find column names that do not follow naming convention by @mfvanek in #85
- Update README.md by @mfvanek in #86
- Add check to find usage of varchar(32/36) instead of uuid for PK by @mfvanek in #87
- Add index size to the output by @mfvanek in #88
- Add check "Don't use varchar(n) by default" by @DGilfanova in #89
- Check to prevent unnecessary where-clauses in index creating queries on not null columns by @mfvanek in #90
- Remove redundant line by @mfvanek in #91
New Contributors
- @DGilfanova made their first contribution in #89
Full Changelog: v.0.14.5...v.0.14.6
v.0.14.5
Full support for partitioned tables
What's Changed
- New year 2025 update by @mfvanek in #69
- Bump super-linter/super-linter from 7.2.1 to 7.3.0 by @dependabot in #70
- Update query to find unused indexes by @mfvanek in #71
- Update linter version for local development by @mfvanek in #72
- Support partitioning for columns checks by @mfvanek in #73
- Support partitioning for indexes with boolean check by @mfvanek in #74
- Support partitioning for duplicated indexes by @mfvanek in #75
- Support partitioning for not valid constraints by @mfvanek in #76
- Support partitioning for foreign keys by @mfvanek in #77
- Support partitioning by @mfvanek in #78
- Support partitioning for FK by @mfvanek in #79
Full Changelog: v.0.14.4...v.0.14.5
v.0.14.4
What's Changed
- [PRIMARY_KEYS_WITH_SERIAL_TYPES] Fix for permission denied error by @mfvanek in #68
- [POSSIBLE_OBJECT_NAME_OVERFLOW] Add support for partitioned tables.
- [PRIMARY_KEYS_WITH_SERIAL_TYPES] Add support for partitioned tables.
Full Changelog: v.0.14.3...v.0.14.4
v.0.14.3
What's Changed
- [PRIMARY_KEYS_WITH_SERIAL_TYPES] ERROR: permission denied for schema by @mfvanek in #62
- [TABLES_WITHOUT_DESCRIPTION] Consider to skip partitions of table by @mfvanek in #64
- [TABLES_NOT_LINKED_TO_OTHERS] Decide how to handle partitioned tables by @mfvanek in #65
- [INDEXES_WITH_NULL_VALUES] Enhance support for partitioned tables/indexes by @mfvanek in #66
Full Changelog: v.0.14.0...v.0.14.3