Unlocking high-performance PostgreSQL with key memory optimizations

2 comments

• qeternity 20 hours 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 13 hours ago
    I just ran their query, and it works
• tehlike 1 day ago
  I generally use this: https://pgtune.leopard.in.ua/
  [-]
  • arkh 20 hours ago
    Yup, I was expecting pgtune being mentioned in the article.

    And maybe something like HammerDB to check performances.
  • fix4fun 20 hours ago
    Nice tool. Do you know maybe similar tool for MySQL ?
  • iberator 21 hours ago
    ha first time I visited Ukrainian site NOT about the war! Cool and useful