I tested. The shared buffers works better, then an OS level filesystem cache. The more shared_buffers (but less then database size), the better. With huge_pages is more better. But you must reserve enough free memory for OS and PostgeSQL itself.
> 13 дек. 2018 г., в 18:17, Ron <ronljohnso...@gmail.com> написал(а): > > Hi, > > https://www.postgresql.org/docs/9.6/runtime-config-resource.html > > The docs say, "If you have a dedicated database server with 1GB or more of > RAM, a reasonable starting value for shared_buffers is 25%". > > But that's pretty archaic in 2018. What if the dedicated database server has > 128GB RAM? > > Thanks. > > -- > Angular momentum makes the world go 'round. >
