Unlocking high-performance PostgreSQL with key memory optimizations

92 pointsposted 5 days ago
by camille_134
(stormatics.tech)

6 Comments

qeternity

19 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

12 hours ago

I just ran their query, and it works

tehlike

a 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

19 hours ago

Nice tool. Do you know maybe similar tool for MySQL ?

iberator

20 hours ago

ha first time I visited Ukrainian site NOT about the war! Cool and useful