2 ms·
"In Linux, the most popular host for Postgres, the size of the OS disk cache cannot be set by the user." True, though you can tweak settings on when the cache
by tyingq 8y ago
"In Linux, the most popular host for Postgres, the size of the OS disk cache cannot be set by the user."
True, though you can tweak settings on when the cache writes dirty pages. Percona has a blog post specific to Postgres that covers it.
There's also some other tuning there not mentioned in the HN linked story.
https://www.percona.com/blog/2018/08/29/tune-linux-kernel-parameters-for-postgresql-optimization/ https://www.percona.com/blog/2018/08/29/tune-linux-kernel-pa...