I tested. The shared buffers works better, then an OS level filesystem cache. The more shared_buffers (but less then
databasesize), 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@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_buffersis 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.
>