Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql not getting assigned memory - Mailing list pgsql-general

From Abdul Sayeed
Subject Re: Postgresql not getting assigned memory
Date
Msg-id CAHb=FFzF+J8OvjtLZMoeWzVVAOmHevn1TXjKC6izi-Hr9x-Vnw@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql not getting assigned memory  (Oliver <ofabelo@gmail.com>)
List pgsql-general
Tree view
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@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 <abdulsayeed24@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:



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



pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: max_connections reached in postgres 9.3.3
Next
From: Kevin Grittner
Date:
Subject: Re: Postgresql not getting assigned memory