Unlocking high-performance PostgreSQL with key memory optimizations

(stormatics.tech)

94 points | by camille_134 5 days ago

2 comments

qeternity 1 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 1 day ago
  
  I just ran their query, and it works
  
  [-]
  - qeternity 1 hour ago
    
    It does not in PG17.
tehlike 1 day ago

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

[-]
- arkh 1 day ago
  
  Yup, I was expecting pgtune being mentioned in the article.
  And maybe something like HammerDB to check performances.
- fix4fun 1 day ago
  
  Nice tool. Do you know maybe similar tool for MySQL ?
- iberator 1 day ago
  
  [flagged]