References: 
 <CALQkqm_BqAU9Nh=morY6ON02fGjZ228YfAEkBeqZwA5QPjh5wg@mail.gmail.com>
	<8b8abf0c137c0dac2d29c163537a7ea2@imap.lan.net>
	<CALQkqm-69GZtNU+sxehM7PAYS1SPjjN_N3=b2diG4UFTA3zHWA@mail.gmail.com>
	<1403268386.87807.YahooMailNeo@web122301.mail.ne1.yahoo.com>
 <CALQkqm-ni-3UtBUrGJmeq-pr2+2As4YZeMgMzN8BO5pE_s1uuQ@mail.gmail.com>
Message-ID: <1403269359.63758.YahooMailNeo@web122304.mail.ne1.yahoo.com>
Date: Fri, 20 Jun 2014 06:02:39 -0700
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: Postgresql not getting assigned memory
To: Oliver <ofabelo@gmail.com>
Cc: Jan Lentfer <Jan.Lentfer@web.de>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <CALQkqm-ni-3UtBUrGJmeq-pr2+2As4YZeMgMzN8BO5pE_s1uuQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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.=A0 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


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin