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.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
