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. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
