Re: How to make a REALLY FAST db server?

> 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