Re: [GENERAL] server hardware recommendations (the archives are dead)

On Wed, 15 Dec 1999, Adam Rossi wrote:

> I know this question has been asked before. I have seen it in the archives.
> Unfortunately the archives are dead right now (any search will yield "no
> results") and I need to make some decisions.
>
> Can anyone give some general recommendations on hardware for a server
> running Linux (RH6 or 6.1) and PostgreSQL? I estimate that there will be
> about 2 GIG of data stored in the database initially, but this could grow as
> high as 5 GIG in the future.
>
> Since the db is not multithreaded, I assume that buying a dual processor
> board and two processors would not be helpful to performance. Like any

actually, if you are going to have concurrent connections to the backend,
in some circumstances, PostgreSQL will handle multi-processors better then
others...process one runs on CPU0, process two runs on CPU1, etc...

> database server, a lot of ram will be required for fast operation. I was
> thinking at a minimum 256 meg of ram. I also want to have the database run
> on a RAID 5 array for speed and fault tolerance. Any suggestions here for
> disk type, RAID scheme (software or hardware), controller type, etc.? Any

my preference tends to be software raid...whatever I've ever seen as far
as hardware raid is concerned has been quite slower then software
raid...and this is with high-end servers...

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org