Hi, On Thu, Nov 14, 2013 at 7:14 PM, Alexander Farber < alexander.far...@gmail.com> wrote:
> 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 > > You may want to look at effective_cache_size also. May be quickly go through http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server and see what http://pgfoundry.org/projects/pgtune/ says. Jayadevan
