Would love to get some advice on how to change my conf settings / setup
to get better I/O performance.
2x Intel Xeon Quad Core (@2 Ghz - Clovertown,L5335)
4x Seagate 73GB SAS HDD 10k RPM - in RAID ( stripped and mirrored )
~1500 databases w/ ~60 tables each
Total I/O (these number are pretty constant throughout the day):
Reads: ~ 100 / sec for about 2.6 Mb/sec
Writes: ~ 400 /sec for about 46.1Mb/sec
listen_addresses = '*'
max_connections = 600
ssl = on
password_encryption = on
shared_buffers = 1GB
work_mem = 5MB
maintenance_work_mem = 256MB
max_fsm_pages = 2800000
max_fsm_relations = 160000
synchronous_commit = off
checkpoint_segments = 6
checkpoint_warning = 30s
effective_cache_size = 1GB
This server also handles web traffic and PHP script processing.
Most of the SQL happening is selects - very little inserts, updates and
I have noticed that most/all of the I/O activity is coming from the
stats collector and autovacuum processes. Would turning off the stats
collector and autovacuum be helpeful / recommended? Could I change my
checkpoint_* or bgwriter_* conf values to help?
Let me know if you need more information / stats.
Any help would be much appreciated.
CIO / Lead Developer
pgsql-performance by date
|Next:||From: Magnus Hagander||Date: 2009-09-03 07:51:49|
|Subject: Re: Help: how to speed up query after db server reboot|
|Previous:||From: Greg Jaman||Date: 2009-09-02 20:31:29|
|Subject: Re: partition query using Seq Scan even when index is present|