Shared Buffer Size
От
preetika tyagi
Тема
Shared Buffer Size
Дата
Msg-id
BANLkTikPn1k2cvMyM6t-VCSXGExuL5wYvQ@mail.gmail.com
Список
Дерево обсуждения
Shared Buffer Size preetika tyagi <preetikatyagi@gmail.com>
Re: Shared Buffer Size Derrick Rice <derrick.rice@gmail.com>
Re: Shared Buffer Size preetika tyagi <preetikatyagi@gmail.com>
Re: Shared Buffer Size Greg Smith <greg@2ndQuadrant.com>
Re: Shared Buffer Size Carl von Clausewitz <clausewitz45@gmail.com>
Re: Shared Buffer Size Greg Smith <greg@2ndQuadrant.com>
Re: Shared Buffer Size Toby Corkindale <toby.corkindale@strategicdata.com.au>
Re: Shared Buffer Size Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: Shared Buffer Size Toby Corkindale <toby.corkindale@strategicdata.com.au>
Re: Shared Buffer Size Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: Shared Buffer Size Carl von Clausewitz <clausewitz45@gmail.com>
Re: Shared Buffer Size Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: Shared Buffer Size preetika tyagi <preetikatyagi@gmail.com>
Hi All,
I am little confused about the internal working of PostgreSQL. There is a parameter shared_buffer in postgres.conf and I am assuming that it is used for buffer management in PostgreSQL. If there is a need to bring in a new page in the buffer and size exceeds the shared_buffer limit, a victim dirty page will be written back to the disk.
However, I have read on many links that PostgreSQL depends on the OS for caching. (http://www.varlena.com/GeneralBits/Tidbits/perf.html#shbuf)
So my question is, the actual limit of the shared buffer will be defined by OS or the shared_buffer parameter in the postgres.conf to figure whether a victim dirty page needs to be selected for disk write or not?
Thanks!
I am little confused about the internal working of PostgreSQL. There is a parameter shared_buffer in postgres.conf and I am assuming that it is used for buffer management in PostgreSQL. If there is a need to bring in a new page in the buffer and size exceeds the shared_buffer limit, a victim dirty page will be written back to the disk.
However, I have read on many links that PostgreSQL depends on the OS for caching. (http://www.varlena.com/GeneralBits/Tidbits/perf.html#shbuf)
So my question is, the actual limit of the shared buffer will be defined by OS or the shared_buffer parameter in the postgres.conf to figure whether a victim dirty page needs to be selected for disk write or not?
Thanks!
В списке pgsql-general по дате отправления
От: Samuel Gendler
Дата:
От: David Johnston
Дата: