Hi,
I have a 64 bit Opteron m/c with 32GB RAM and ~500GB HardDrive. The database
size is ~45GB.
I am using the following values in postgresql.conf:
shared_buffers = 100000
work_mem = 128000
maintenance_work_mem = 100000
max_fsm_pages = 200000
bgwriter_percent = 0
bgwriter_maxpages = 0
fsync = false
wal_buffers = 1000
checkpoint_segments = 2048
checkpoint_timeout = 3600
effective_cache_size = 1840000
random_page_cost = 2
geqo_threshold = 25
geqo_effort = 1
stats_start_collector = false
stats_command_string = false
Do these settings seem fine or I am making some mistake. These settings when
used with Postgres 7.4 gave me good results but they don't seem to work with
Postgres 8.0. Am I missing out on something??
Regards,
Vinita Bansal
_________________________________________________________________
Click, Upload, Print. http://www.kodakexpress.co.in?soe=4956 Deliver in
India.