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