I've saved my company more than $20,000 by convincing them to switch
from MS SQL Server to PostgreSQL and building a DB server that meets
our needs. Here are the basic DB server specs:
Dual 1.4 Ghz Athlon
1GB DDR RAM
RedHat 7.2
IDE software RAID 1 (two 40GB IBM 60GXP)
(btw, I had a budget of $1200 to build this system, which I made
easily)
I have the system up and running, and everything is going great. The
company is happy and we have extra money for R&D. I am fairly new to
PostgreSQL, however, and have done my best to optimize PostgreSQL for
this box, but I would like to get some counsel from those of you more
experienced with PostgreSQL on what you would think the best settings
would be for this kind of setup. Here is my postgresql.conf file
(edited):
The more important settings:
sort_mem = 16384
shared_buffers = 96000
effective_cache_size = 18200 # default in 8k pages
wal_buffers = 32 # min 4
wal_files = 64 # range 0-64
deadlock_timeout = 5000
The rest of the settings are all commented out or have their default
values.
We are running PostgreSQL 7.1.3. When considering these settings,
remember that this machine is pretty much dedicated to PostgreSQL.
As far as the OS itself goes, I have optimized the hard drives using
hdparm (UDMA 5, 32-bit, blah, blah) and have increased the shared mem
size to handle the settings I have above. The drive (raid) is using
the ext3 filesystem.
Thanks for your consideration.
