Set shared_buffers more
accurately by using pg_buffercache extension and the related queries
during high load times.
Regards,
Michael Vitale
Tuesday,
March 12, 2019 3:23 PM 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)?
|
