Hi,
thanks for replying.
Yes, I've seen that information in that file was introduced by initdb
initially. When I restart the server/PGSQL it appends/adds information to
that file, wihout modifying information that was introduced initially by
initdb .. so I'm sure that initdb was executed only once.
On Fri, Jun 20, 2014 at 4:51 AM, Oliver 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 postgres
Oliver wrote:
> 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?
It's usually much better to copy/paste what you're talking about
than to just refer
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 wrote:
> Thank you
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 m
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
