From: | Abdul Sayeed <abdulsayeed24(at)gmail(dot)com> |
---|---|
To: | Oliver <ofabelo(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, Forums postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgresql not getting assigned memory |
Date: | 2014-06-20 12:54:51 |
Message-ID: | CAHb=FFwmqN=Q5HG8jafUkqyJxHGFQCGFJ4Kq0yXsyrmuy-SBEQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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(at)gmail(dot)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...
>
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver | 2014-06-20 12:55:22 | Re: Postgresql not getting assigned memory |
Previous Message | Kevin Grittner | 2014-06-20 12:46:26 | Re: Postgresql not getting assigned memory |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver | 2014-06-20 12:55:22 | Re: Postgresql not getting assigned memory |
Previous Message | Kevin Grittner | 2014-06-20 12:46:26 | Re: Postgresql not getting assigned memory |