How to make a REALLY FAST db server? - Mailing list pgsql-general

From bpalmer
Subject How to make a REALLY FAST db server?
Date
Msg-id Pine.BSO.4.33.0109101445080.18431-100000@mizer.crimelabs.net
Whole thread Raw
Responses Re: How to make a REALLY FAST db server?
Re: How to make a REALLY FAST db server?
Re: How to make a REALLY FAST db server?
List pgsql-general
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
- OS:  Prolly FreeBSD (FFS is your friend (what with syncs and all) and it
can do multi proc support
- Disk:  SCSI Raid 1+0
- 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.

Any people have any comments?

- Brandon


----------------------------------------------------------------------------
 b. palmer,  bpalmer@crimelabs.net            pgp:crimelabs.net/bpalmer.pgp5


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Supporting PostgreSQL infrastructure
Next
From: "Jeff Eckermann"
Date:
Subject: Re: SQL Loader?