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)?