working_notes.md

• profile dashboard queries

  • time profiling
  • EXPLAIN
    • ANALYZE
    • VERBOSE -https://www.postgresql.org/docs/current/sql-explain.html

• optimize queries

• add indexes

  • indexing strategy on low cardinality data. https://www.postgresql.org/docs/15/sql-createindex.html

• upgrade hardware -rpi --> m900

  • stats
  • CICD deployment?

• improve data management strategy

  • materialized views.
    • will not work directly, as postgres refresh is full https://www.postgresql.org/docs/15/rules-materializedviews.html
  • stored procs to compact data.
  • data retention policies.