This topic seems to be always open to discussion. In my opinion, it depends on how big your work dataset is, there's no use in sizing shared_buffers beyond that size. I think, the most reasonable thing is analyzing each case as proposed here: https://www.keithf4.com/a-large-database-does-not-mean-large-shared_buffers/
- shared_buffers on Big RAM systems Ron
- Re: shared_buffers on Big RAM systems Rene Romero Benavides
- Installing pg_buffercache (was Re: shar... Ron
- Re: Installing pg_buffercache (was ... Guillaume Lelarge
- Re: shared_buffers on Big RAM systems Thomas Munro
- Re: shared_buffers on Big RAM systems Jeff Janes
- Re: shared_buffers on Big RAM syste... Andres Freund
- Re: shared_buffers on Big RAM systems Олег Самойлов