94 points | by camille_134 5 days ago
2 comments
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;
I just ran their query, and it works
I generally use this: https://pgtune.leopard.in.ua/
Yup, I was expecting pgtune being mentioned in the article.
And maybe something like HammerDB to check performances.
Nice tool. Do you know maybe similar tool for MySQL ?
ha first time I visited Ukrainian site NOT about the war! Cool and useful
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;
I just ran their query, and it works
I generally use this: https://pgtune.leopard.in.ua/
Yup, I was expecting pgtune being mentioned in the article.
And maybe something like HammerDB to check performances.
Nice tool. Do you know maybe similar tool for MySQL ?
ha first time I visited Ukrainian site NOT about the war! Cool and useful