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.far...@gmail.com> wrote: > And pgtune is 4 years old... > > >