> I'm looking to make a DB server for a project I'm working on (using pgsql)
> and am wondering if people have suggestions?
>
> Thoughts:
>
> - Hardware: dual / quad Intel class
OK, but remember I/O is key for databases. The more spindles the
better. See my performance article on techdocs.
> - OS: Prolly FreeBSD (FFS is your friend (what with syncs and all) and it
> can do multi proc support
I would recommend soft updates be enabled.
> - Disk: SCSI Raid 1+0
Not sure about that. Is that optimal for I/O?
> - Ram: Not really sure here. Is there math somewhere for ram needs for
> pgsql? I imagine is has something to do with # connections, db size,
> etc.
Again, see article.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026