Re: [GENERAL] server hardware recommendations (the archives are dead) - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] server hardware recommendations (the archives are dead)
Date
Msg-id 199912152346.SAA08962@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] server hardware recommendations (the archives are dead)  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-general
> 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...

I have removed multi-threaded from our comparison web page.  It confused
too many people.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@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

pgsql-general by date:

Previous
From: "Patrick Welche"
Date:
Subject: Foreign key
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] server hardware recommendations (the archives aredead)