Postgres Pro
Downloads
Home   >   mailing lists

Re: Tuning 9.3 for 32 GB RAM - Mailing list pgsql-general

From Alexander Farber
Subject Re: Tuning 9.3 for 32 GB RAM
Date
Msg-id CAADeyWhE=0vvX-zoENPH+XAsr+-0fSAyCpg2TjCp_1YY6oHVGg@mail.gmail.com
Whole thread Raw
In response to Re: Tuning 9.3 for 32 GB RAM  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: Tuning 9.3 for 32 GB RAM
Re: Tuning 9.3 for 32 GB RAM
List pgsql-general
Tree view
pgtune has produced the following for my server (the specs: http://www.hetzner.de/en/hosting/produkte_rootserver/px60ssd ):

default_statistics_target = 50
maintenance_work_mem = 1GB
constraint_exclusion = on
checkpoint_completion_target = 0.9
effective_cache_size = 22GB
work_mem = 192MB
wal_buffers = 8MB
checkpoint_segments = 16
shared_buffers = 7680MB
max_connections = 80

Is it really okay? Isn't 22GB too high?
And how does it know that max_connections =80 is enough in my case? (I use pgbouncer).

Regards
Alex






On Thu, Nov 14, 2013 at 4:04 PM, Alexander Farber <alexander.farber@gmail.com> wrote:
And pgtune is 4 years old...



pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Tuning 9.3 for 32 GB RAM
Next
From: Dang Minh Huong
Date:
Subject: Equivalent syntax of PL/SQL using array in PL/pgSQL