Re: Postgresql not getting assigned memory

[Oliver <ofabelo@xxxxxxxxx>]

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@xxxxxxxxx>:

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