Conclusions and Recommendations for all P1
TODO / How to implement
A004 Are there any HA replicas being used? - manual-
F001 Autovacuum: Current settings - Any tuning applied (values are not default)? -
F008 autovacuum_max_workers is not default? when CPU cores >= 16 -
F008 autovacuum_vacuum_cost_limit / vacuum_cost_limit is not default -
G001 Low level of OOM risks? (??how we check it) -
G001 Is memory usage correct? shared_buffers 20%-80% of RAM ??? -
G002 There are no "idle in tx" lasting > 1 hour? -
G002 There are no "active" lasting > 1 hour? -
K003 There are no query groups which total_time is >50% of overall total_time (30-40%?) -
L003 There are no tables with int4/int2 PK, where max value exceeded 10% of capacity (2^31)
Acceptance criteria
As a user of postgres-checkup, I see Conclusions and Recommendations for most critical issues (P1).
Edited by Anna