Oliver <ofabelo@gmail.com> wrote:
> I only want be sure about shared_buffers parameter. What I set
> there, is it memory that postgresql will use (will allocate)
> initially (when it is started) or memory until that postgresql
> can reach of the server?
It is part of the main shared memory segment allocated when the
database service starts, and to which every backend connects. Each
backend makes other allocations from the OS, which are not
consrtained by this setting.
PostgreSQL goes through the OS filesystems, so the OS cache and
buffers are also used for PostgreSQL data.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company