On Mon, Oct 5, 2015 at 9:51 AM, FattahRozzaq <ssoorruu@xxxxxxxxx> 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_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. How did you measure that? merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
