logoalt Hacker News

Unlocking high-performance PostgreSQL with key memory optimizations

89 pointsby camille_134last Monday at 7:05 AM6 commentsview on HN

Comments

qeternitytoday at 11:18 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;

tehliketoday at 6:30 AM

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

show 3 replies