Re: Tuning 9.3 for 32 GB RAM

Hi,

On Thu, Nov 14, 2013 at 7:14 PM, Alexander Farber <
alexander(dot)farber(at)gmail(dot)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