[GENERAL] effective_cache_size and work_ram

[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?

Thanks
ac