2/2/2026 at 7:05:56 AM
by camille_134
2/6/2026 at 11:18:10 AM
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;
by qeternity
2/6/2026 at 6:08:11 PM
I just ran their query, and it worksby itiswatitis
2/6/2026 at 6:30:10 AM
I generally use this: https://pgtune.leopard.in.ua/by tehlike
2/6/2026 at 10:44:30 AM
Yup, I was expecting pgtune being mentioned in the article.And maybe something like HammerDB to check performances.
by arkh
2/6/2026 at 10:57:17 AM
Nice tool. Do you know maybe similar tool for MySQL ?by fix4fun
2/6/2026 at 10:36:32 AM
ha first time I visited Ukrainian site NOT about the war! Cool and usefulby iberator