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 <ronljohnsonjr@xxxxxxxxx> написал(а): > > 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. >
