hello 2012/12/12 a...@hsk.hk <a...@hsk.hk>: > 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?
it is dedicated server? then effective_cache_size can be higher maybe 6GB checkpoint_segments are too low, can be 128 Regards Pavel Stehule > > Thanks > ac -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
