Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-07 Thread Merlin Moncure
On Wed, Oct 7, 2015 at 5:29 AM, FattahRozzaq wrote: > Response from you all are very precious. > > @Merlin, > I'm misunderstood the question. > Yes, I didn't measure it. I only monitor RAM and CPU using htop (I also use Can you be a little more specific. What values did you look at and how did y

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-07 Thread Scott Marlowe
On Wed, Oct 7, 2015 at 4:29 AM, FattahRozzaq wrote: > Response from you all are very precious. > > @Merlin, > I'm misunderstood the question. > Yes, I didn't measure it. I only monitor RAM and CPU using htop (I also use > nmon for disk IO, iftop for the network utilization). > Did 1 connection nee

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-07 Thread FattahRozzaq
Response from you all are very precious. @Merlin, I'm misunderstood the question. Yes, I didn't measure it. I only monitor RAM and CPU using htop (I also use nmon for disk IO, iftop for the network utilization). Did 1 connection need 1 core dedicatedly? (I was having 40-80 connections in stable co

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-06 Thread Josh Berkus
On 10/06/2015 02:33 AM, FattahRozzaq wrote: > @Merlin Moncure, I got the calculation using pg_tune. And I modified > the shared_buffers=24GB and the effective_cache_size=64GB I really need to get Greg to take down pg_tune. It's way out of date. Probably, I should replace it. -- Josh Berkus Post

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-06 Thread Merlin Moncure
On Tue, Oct 6, 2015 at 10:10 AM, Scott Marlowe wrote: > On Tue, Oct 6, 2015 at 3:33 AM, FattahRozzaq wrote: >> @Merlin Moncure, I got the calculation using pg_tune. And I modified >> the shared_buffers=24GB and the effective_cache_size=64GB >> >> @Igor Neyman, >> Yes, I had performance problem wh

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-06 Thread Scott Marlowe
On Tue, Oct 6, 2015 at 3:33 AM, FattahRozzaq wrote: > @Merlin Moncure, I got the calculation using pg_tune. And I modified > the shared_buffers=24GB and the effective_cache_size=64GB > > @Igor Neyman, > Yes, I had performance problem which sometimes the response time took > 11ms, with the exactly

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-06 Thread FattahRozzaq
formance@postgresql.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'

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-05 Thread Igor Neyman
RAM only use 4-5 GB average -Original Message- From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of FattahRozzaq Sent: Monday, October 05, 2015 10:51 AM To: pgsql-performance@postgresql.org Subject: [PERFORM] shared-buffers set to 24GB

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-05 Thread Igor Neyman
-Original Message- From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of FattahRozzaq Sent: Monday, October 05, 2015 10:51 AM To: pgsql-performance@postgresql.org Subject: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5

Re: [PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-05 Thread Merlin Moncure
On Mon, Oct 5, 2015 at 9:51 AM, FattahRozzaq wrote: > 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_

[PERFORM] shared-buffers set to 24GB but the RAM only use 4-5 GB average

2015-10-05 Thread FattahRozzaq
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