Re: [GENERAL] Postgresql not getting assigned memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux