Re: Postgresql not getting assigned memory

Hi,

It shows 2GB. It means it is updated. Shared_buffer memory is used at
postgresql database level, It will consume while doing operation such as
INSERT, UPDATE, DELETE and other maintenance task (VACUUM/VACUUM FULL).

Thanks,
Abdul

On Fri, Jun 20, 2014 at 6:28 PM, Oliver <ofabelo(at)gmail(dot)com> wrote:

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