Skip to content

feat: dynamic adjustments for databases with huge amount of objects

Dmitry requested to merge 419-dmius-dynamic-adjustments into master

Description

For speed up the performance of checkup which executed on large databases (with more than 100000 metadata records for indexes or tables), we were analyzing in F004, F005, H002 and H003 reports only objects with size more 10-100 relpages.
But this is the reason why checkup can't analyze small tables and indexes on small databases(with less than 100000 metadata records for indexes or tables).
In current update implemented dynamic detection of database size and adjustment min relpages value for analyzed objects.
Displaying min analyzed object size base on value from JSON added to report in the case when min object size larger than 0.
Also prepared test environment(script for generation large database) and test added for cases when small indexes should be not found on a large database and should be found on a small database.

NB! CI test with 100000 metadata record lasts about 14 minutes.

Related issue

#419 (closed)

Examples

smalldb

largedb

f004notice

h003notice

Closes #419 (closed).

Edited by Anatoly Stansler

Merge request reports