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
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?
pgsql-general by date
|Next:||From: David Johnston||Date: 2011-05-27 20:48:42|
|Subject: Re: SELECT COUNT(*) execution time on large tables (v9.0.4-1)|
|Previous:||From: Samuel Gendler||Date: 2011-05-27 19:28:22|
|Subject: Re: [SQL] Re: 500KB PDF files for postgresql8.3, which is the most