Skip to content

Releases: mfvanek/pg-index-health-sql

v.0.30.0

12 Oct 07:10
b588900
Compare
Choose a tag to compare

What's Changed

Full Changelog: v.0.20.3...v.0.30.0

v.0.20.3

28 Sep 08:24
f31c380
Compare
Choose a tag to compare

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

26 Jun 14:22
9757d4d
Compare
Choose a tag to compare

What's Changed

Full Changelog: v.0.20.1...v.0.20.2

v.0.20.1

16 Jun 18:50
a3587c5
Compare
Choose a tag to compare

What's Changed

Full Changelog: v.0.15.0...v.0.20.1

v.0.15.0

07 Jun 17:17
647b5d5
Compare
Choose a tag to compare

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

20 Apr 18:06
b467a66
Compare
Choose a tag to compare

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

Full Changelog: v.0.14.5...v.0.14.6

v.0.14.5

02 Apr 15:54
438c1ab
Compare
Choose a tag to compare

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

21 Dec 06:52
19e50d7
Compare
Choose a tag to compare

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

12 Dec 05:48
eebce6a
Compare
Choose a tag to compare

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

v.0.14.0

26 Nov 17:38
6db61f7
Compare
Choose a tag to compare

What's Changed

Full Changelog: v.0.13.3...v.0.14.0