Hardware for PostgreSQL - Mailing list pgsql-performance

From Ketema
Subject Hardware for PostgreSQL
Date
Msg-id 1193849108.591961.103570@22g2000hsm.googlegroups.com
Whole thread Raw
Responses Re: Hardware for PostgreSQL  (Magnus Hagander <magnus@hagander.net>)
Re: Hardware for PostgreSQL  (Arjen van der Meijden <acmmailing@tweakers.net>)
Re: Hardware for PostgreSQL  (Tomas Vondra <tv@fuzzy.cz>)
Re: Hardware for PostgreSQL  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Hardware for PostgreSQL  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Hardware for PostgreSQL  (Jurgen Haan <jurgen@easyflex.nl>)
Re: Hardware for PostgreSQL  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-performance
I am trying to build a very Robust DB server that will support 1000+
concurrent users (all ready have seen max of 237 no pooling being
used).  I have read so many articles now that I am just saturated.  I
have a general idea but would like feedback from others.

I understand query tuning and table design play a large role in
performance, but taking that factor away
and focusing on just hardware, what is the best hardware to get for Pg
to work at the highest level
(meaning speed at returning results)?

How does pg utilize multiple processors?  The more the better?
Are queries spread across multiple processors?
Is Pg 64 bit?
If so what processors are recommended?

I read this : http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance/node12.html
POSTGRESQL uses a multi-process model, meaning each database
connection has its own Unix process. Because of this, all multi-cpu
operating systems can spread multiple database connections among the
available CPUs. However, if only a single database connection is
active, it can only use one CPU. POSTGRESQL does not use multi-
threading to allow a single process to use multiple CPUs.

Its pretty old (2003) but is it still accurate?  if this statement is
accurate how would it affect connection pooling software like pg_pool?

RAM?  The more the merrier right? Understanding shmmax and the pg
config file parameters for shared mem has to be adjusted to use it.
Disks?  standard Raid rules right?  1 for safety 5 for best mix of
performance and safety?
Any preference of SCSI over SATA? What about using a High speed (fibre
channel) mass storage device?

Who has built the biggest baddest Pg server out there and what do you
use?

Thanks!


pgsql-performance by date:

Previous
From: "Steven Flatt"
Date:
Subject: Re: tables with 300+ partitions
Next
From: Ben
Date:
Subject: Re: hardware and For PostgreSQL