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 <ofab...@gmail.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 <abdulsayee...@gmail.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 <ofab...@gmail.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... >>> >> >> >
