From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
---|---|
To: | Igor Neyman <ineyman(at)perceptron(dot)com>, FattahRozzaq <ssoorruu(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average |
Date: | 2015-10-05 18:29:12 |
Message-ID: | A76B25F2823E954C9E45E32FA49D70ECCD54DC7B@mail.corp.perceptron.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Igor Neyman
Sent: Monday, October 05, 2015 2:25 PM
To: FattahRozzaq <ssoorruu(at)gmail(dot)com>; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average
-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of FattahRozzaq
Sent: Monday, October 05, 2015 10:51 AM
To: pgsql-performance(at)postgresql(dot)org
Subject: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average
I have configured postgresql.conf with parameters as below:
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
listen_addresses = '*'
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
log_rotation_age = 1d
log_rotation_size = 1024MB
listen_addresses = '*'
checkpoint_segments = 64
wal_keep_segments = 128
max_connections = 9999
max_prepared_transactions = 9999
checkpoint_completion_target = 0.9
default_statistics_target = 10
maintenance_work_mem = 1GB
effective_cache_size = 64GB
shared_buffers = 24GB
work_mem = 5MB
wal_buffers = 8MB
port = 40003
pooler_port = 40053
gtm_host = 'node03'
gtm_port = 10053
As you can see, I have set the shared_buffers to 24GB, but my server still only use 4-5 GB average.
I have 128GB RAM in a single server.
My database has 2 tables:
- room (3GB size if pg_dump'ed)
- message (17GB if pg_dump'ed)
The backend application is a messaging server, in average there will be 40-180 connections to the postgres Server.
The traffic is quite almost-heavy.
How to make postgres-xl effectively utilizes the resource of RAM for
9999 max_connections?
Thanks,
FattahRozzaq
____________________________________
Why are you looking at memory consumption?
Are you experiencing performance problems?
Regards,
Igor Neyman
_______________________
Also,
Postgres-xl has it's own mailing lists:
http://sourceforge.net/p/postgres-xl/mailman/
Regards,
Igor Neyman
From | Date | Subject | |
---|---|---|---|
Next Message | Carlo | 2015-10-06 03:10:49 | One long transaction or multiple short transactions? |
Previous Message | Igor Neyman | 2015-10-05 18:24:40 | Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average |