Unlocking high-performance PostgreSQL with key memory optimizations 5 days ago (stormatics.tech) 6 comments camille_134 Reply Add to library 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 18 hours ago I just ran their query, and it works 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 ha first time I visited Ukrainian site NOT about the war! Cool and useful
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 18 hours ago I just ran their query, and it works
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 ha first time I visited Ukrainian site NOT about the war! Cool and useful
arkh 1 day ago Yup, I was expecting pgtune being mentioned in the article.And maybe something like HammerDB to check performances.
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