Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql not getting assigned memory - Mailing list pgsql-admin

From Oliver
Subject Re: Postgresql not getting assigned memory
Date
Msg-id CALQkqm-69GZtNU+sxehM7PAYS1SPjjN_N3=b2diG4UFTA3zHWA@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql not getting assigned memory  (Jan Lentfer <Jan.Lentfer@web.de>)
Responses Re: Postgresql not getting assigned memory
List pgsql-admin
Tree view
I'm sorry, I've renamed pg_startup.log for when postgresql was restarted, file would be recreated, but it only appends information about that the output of the register will appear in the directory pg_log .. it doesn't return to show server configuration data, so I suppose that 128MB of shared_buffers is an entry about postgresql was created for first time.
Although, I continue not being sure about if it is getting assigned 2048MB .. because I run top command and it shows little memory used (total 8GB, used 340MB, free 7.6GB).
With 2048MB as shared_buffers, it should assined initially when postgresql server starts or it starts with a memory and it can grow until 2048MB?

$ more PG_VERSION 
9.3

Thanks beforehand.

Cheers...


2014-06-20 13:00 GMT+01:00 Jan Lentfer <Jan.Lentfer@web.de>:
Am 2014-06-20 13:51, schrieb Oliver:
[...]

When I restart instance or even server, pgstartup.log indicates:

seleccionando el valor para shared_buffers ... 128MB (I'm sorry, I'm
spanish and server is configured in spanish). But it shows something
as: selecting shared_buffers value ... 128MB.

set lc_messages = 'C' in postgresql.conf to get english logs.

What version of postgres is this? If it's is lower than 9.3 you might need to read this:
http://www.postgresql.org/docs/9.2/static/kernel-resources.html

hth

Jan


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

pgsql-admin by date:

Previous
From: Jan Lentfer
Date:
Subject: Re: Postgresql not getting assigned memory
Next
From: Kevin Grittner
Date:
Subject: Re: Postgresql not getting assigned memory