Re: How to make a REALLY FAST db server?

>> - 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.

Good points.

>> - Disk: SCSI Raid 1+0
>
>Not sure about that. Is that optimal for I/O?

From my experience it is. As long as you have a raid controler that
can do 2 level RAID abstraction. First you need mirrored pairs and
then you stripe over them. It costs a lot in disk, but is stupid fast
with the right raid controller. With some Suns / FC / EMC, we were
getting ~100M/s+ with that setup for our Oracle server.

>> - 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.

Thanks.

----------------------------------------------------------------------------
b. palmer, bpalmer(at)crimelabs(dot)net pgp:crimelabs.net/bpalmer.pgp5