« BackUnlocking high-performance PostgreSQL with key memory optimizationsstormatics.techSubmitted by camille_134 5 days ago
  • qeternity a day ago

    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;

    • itiswatitis 18 hours ago

      I just ran their query, and it works

    • tehlike a day ago

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

      • arkh a day ago

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

        And maybe something like HammerDB to check performances.

        • fix4fun a day ago

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

          • iberator a day ago

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