Skip to content

H002: build list of redundant indexes fixed, generation json data for indexes fixed

Dmitry requested to merge dmius-h002-redundant-fix into master

Description

In some cases some partial indexes and indexes with conditions we have recommended to remove as redundant. Incorrect conditions was removed from code, so now it should detect redundant indexes more correctly. Also in cases when schema where placed table of index is null such indexes can be skipped in json code. It fixed in this MR too.

  • the MR description has been reviewed
  • this MR contains text changes and they have been reviewed OR there are no texts changes
  • this MR contains GUI/CLI changes and they have been reviewed OR there are no GUI/CLI changes
  • this MR contains API changes and they have been reviewed OR there are no API changes

Related issue

https://gitlab.com/postgres-ai/postgres-checkup/issues/460 https://gitlab.com/postgres-ai/postgres-checkup/issues/470

Examples

Edited by Anatoly Stansler

Merge request reports