Re: Shared_buffers
| От | Michael Lewis |
|---|---|
| Тема | Re: Shared_buffers |
| Дата | |
| Msg-id | CAHOFxGqT24bb_G9Ej3jAwBDLizfK1dwb+rXo62mP4zjB6iDRpA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Shared_buffers (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: Shared_buffers
|
| Список | pgsql-performance |
On Tue, Mar 12, 2019 at 2:29 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
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)?
В списке pgsql-performance по дате отправления: