camille_134•5d
Unlocking high-performance PostgreSQL with key memory optimizationsstormatics.tech
6 comments
  • qeternity•9h

    Does not instill confidence when the queries they provide don't work.

    For anyone curious, the corrected query:

    SELECT sum(blks_hit)::numeric / nullif(sum(blks_hit + blks_read), 0) AS cache_hit_ratio FROM pg_stat_database;

  • tehlike•14h

    I generally use this: https://pgtune.leopard.in.ua/

    • arkh•9h

      Yup, I was expecting pgtune being mentioned in the article.

      And maybe something like HammerDB to check performances.

    • fix4fun•9h

      Nice tool. Do you know maybe similar tool for MySQL ?

    • iberator•10h

      ha first time I visited Ukrainian site NOT about the war! Cool and useful