Re: Shared_buffers

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Shared_buffers
Date: 2019-03-12 08:29:13
Message-ID: 56099ac31c7cc1a4e8a51963e2674e7fe592b86f.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Lewis 2019-03-12 19:23:52 Re: Shared_buffers
Previous Message Mariel Cherkassky 2019-03-12 07:58:32 Re: ERROR: found xmin from before relfrozenxid