From: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Tuning 9.3 for 32 GB RAM |
Date: | 2013-11-14 13:44:00 |
Message-ID: | CAADeyWjZwEeuCQjekLwLg6qa2WPYTH1DJgpqyRcptGO+Wtqn+w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
do these changes please look okay for a PostgreSQL 9.3 running on CentOS
6.4 server with 32 GB RAM (with Drupal 7 and few custom PHP scripts)
postgresql.conf:
shared_buffers = 4096MB
work_mem = 32MB
checkpoint_segments = 32
log_min_duration_statement = 10000
sysctl.conf:
kernel.shmmax=17179869184
kernel.shmall=4194304
pgbouncer.ini:
listen_port = 6432
unix_socket_dir = /tmp
pool_mode = session
server_reset_query = DISCARD ALL
server_check_delay = 10
max_client_conn = 600
default_pool_size = 50
I understand, that nobody can tell me the optimal settings - unless I
provide full source code to everything. And if I provide "the full source
code", nobody will look at it anyway.
So I am just asking, if the settings look okay or if they will waste
gigabytes of RAM.
Thank you
Alex
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-11-14 14:35:26 | Re: [GENERAL] Clang 3.3 Analyzer Results |
Previous Message | Janek Sendrowski | 2013-11-14 12:05:48 | Re: pg_trgm module: no convertion into Trigrams on one side when comparing |