Re: Postgresql not getting assigned memory

Thank you very much to all.

postgres=# show shared_buffers;
shared_buffers
----------------
2GB
(1 row)

Is it ok then, isn't it? DB hasn't activity now because it is a new
instance, top command indicates only 350MB of used memory .. I understand
that postgresql could reach until 2GB of server memory as total, correct?
Thanks beforehand.

Cheers...

2014-06-20 13:54 GMT+01:00 Abdul Sayeed <abdulsayeed24(at)gmail(dot)com>:

> Hi,
>
> Can you please check the output of below command:
>
> postgres=# show shared_buffers ;
>
>
>
> Thanks & Regards,
> Abdul Sayeed
> System Engineer
>
>
> The Postgres Database Company
>
> Are you updated: Latest version of Postgres Plus Advanced Server are
> 8.4.19.42, 9.0.16.34, 9.1.12.20, 9.2.8.19 and 9.3.4.10
>
> To reach Support Call:
> US: +1-732-331-1320 - UK: +44 - 2033719820
> Brazil: +55-2139581371 - India: +91-20-32676535
>
>
>
> Website: www.enterprisedb.com
> EnterpriseDB Blog : http://blogs.enterprisedb.com
> Follow us on Twitter : http://www.twitter.com/enterprisedb
> ____________________________________________________________
> CONFIDENTIALITY NOTICE
> This e-mail transmission and any documents, files, or previous e-mail
> messages appended or attached to it, may contain information that is
> confidential or legally privileged. If you are not the intended recipient,
> or a person responsible for delivering it to the intended recipient, you
> are hereby notified that you must not read this transmission and that any
> disclosure, copying, printing, distribution, or use of the information
> contained or attached to this transmission is STRICTLY PROHIBITED. If you
> have received this transmission in error, please immediately notify the
> sender by telephone or return e-mail message and delete the original
> transmission, its attachments, and any copies without reading or saving in
> any manner. Thank you.
>
>
> On Fri, Jun 20, 2014 at 5:21 PM, Oliver <ofabelo(at)gmail(dot)com> wrote:
>
>> Hello,
>> I'm new in postgresql, I'm sorry if I do something bad.
>> Default value or shared_buffers is 128MB, I have a dedicated server for
>> postgresql with 8GB RAM. I've changed shared_buffers value to 2048MB and
>> uncommented the entry in postgresql.conf. It shows now:
>>
>> # - Memory -
>>
>> shared_buffers = 2048MB # min 128kB
>>
>> 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.
>> What I do bad? Thanks beforehand.
>>
>> Cheers...
>>
>
>