Hi, yes it is a dedicated server. and THANKS! On 12 Dec 2012, at 3:55 PM, Pavel Stehule wrote: > hello > > 2012/12/12 ac@xxxxxx <ac@xxxxxx>: >> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
