| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | Oliver <ofabelo(at)gmail(dot)com> |
| Cc: | Jan Lentfer <Jan(dot)Lentfer(at)web(dot)de>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Postgresql not getting assigned memory |
| Date: | 2014-06-20 13:02:39 |
| Message-ID: | 1403269359.63758.YahooMailNeo@web122304.mail.ne1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Oliver <ofabelo(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Abdul Sayeed | 2014-06-20 13:14:05 | Re: Postgresql not getting assigned memory |
| Previous Message | Oliver | 2014-06-20 12:58:34 | Re: Postgresql not getting assigned memory |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | enrique.perez | 2014-06-20 13:04:57 | pgAgent |
| Previous Message | Oliver | 2014-06-20 12:58:34 | Re: Postgresql not getting assigned memory |