Claire Chang <yenhsiac@xxxxxxxxx> wrote: > hi, We recently bought a 4 8core 128G memory database server and I > am setting it up to replace our old 4 4cores 128G memory database > server as a master. The memory related settings that we use on > the old machine seem a bit wrong according to the experts on IRC: > max_connections = 600 You're probably going to get better performance by setting that to 2 to 3 times the number of actual cores (don't county hyperthreading for this purpose), and using a connection pooler to funnel the 600 user connections down to a smaller number of database connections. > shared_buffers = 32GB I seem to remember seeing some benchmarks showing that performance falls off after 10GB or 20GB on that setting. > effective_cache_size = 64GB Seems sane. > work_mem = 5MB You could bump that up, especially if you go to the connection pool. > maintenance_work_mem = 1GB OK, but I might double that. > wal_buffers = 64kB This should definitely be set to 16MB. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
