Hi, I have a new server for PostgreSQL 9.2.2 with 8GB physical RAM, I want to turn the server with the following changes from default: max_connections = 100 # default shared_buffers = 2048MB # change from 24MB to 2048MB as I think 24MB is not enough maintenance_work_mem = 400MB # 50MB/GB x 8GB effective_cache_size = 4096MB # Set to 50% of total RAM work_mem = 24MB checkpoint_segments = 10 wal_buffers = 16MB Are these values reasonable? Thanks ac |
