On Tue, Mar 12, 2019 at 2:29 AM Laurenz Albe <laurenz.a...@cybertec.at> wrote:
> Daulat Ram wrote: > > I want to know about the working and importance of shared_buffers in > Postgresql? > > is it similar to the oracle database buffer cache? > > Yes, exactly. > > The main difference is that PostgreSQL uses buffered I/O, while Oracle > usually > uses direct I/O. > > Usually you start with shared_buffers being the minimum of a quarter of the > available RAM and 8 GB. > Any good rule of thumb or write up about when shared buffers in excess of 8GBs makes sense (assuming system ram 64+ GBs perhaps)?