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