Re: Shared_buffers - Mailing list pgsql-performance

From Laurenz Albe
Subject Re: Shared_buffers
Date
Msg-id 56099ac31c7cc1a4e8a51963e2674e7fe592b86f.camel@cybertec.at
Whole thread Raw
In response to Shared_buffers  (Daulat Ram <Daulat.Ram@exponential.com>)
Responses Re: Shared_buffers  (Michael Lewis <mlewis@entrata.com>)
List pgsql-performance
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



pgsql-performance by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Re: ERROR: found xmin from before relfrozenxid
Next
From: Michael Lewis
Date:
Subject: Re: Shared_buffers