From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Ketema <ketema@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Hardware for PostgreSQL
Date: Wed, 31 Oct 2007 16:54:26 -0500
Message-ID: <4728B341.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <1193849108.591961.103570@22g2000hsm.googlegroups.com>
References: <1193849108.591961.103570@22g2000hsm.googlegroups.com>
>>> On Wed, Oct 31, 2007 at 11:45 AM, in message
<1193849108.591961.103570@22g2000hsm.googlegroups.com>, Ketema
<ketema@gmail.com> wrote:
> Who has built the biggest baddest Pg server out there and what do you
> use?
I don't think that would be us, but I can give you an example of
what can work. We have a 220 GB database which is a replication
target for OLTP and supports a web site with about 2 million web
hits per day. Daily, we have about 1 million database transactions
which modify data and 10 million database transactions which are
read-only. The box has 8 4 GHz Xeon processors, 12 GB RAM, and RAID
5 with 13 live spindles and two hot spares. The RAID controller has
256 MB RAM with battery backup. This gives very good performance,
properly tuned.
Besides the PostgreSQL database, the box also runs middle tier
software written in Java.
I'll second the opinions that connection pooling and a high-
quality RAID controller with battery backed RAM cache are crucial.
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, ketema@gmail.com
Subject: Re: Hardware for PostgreSQL
In-Reply-To: <4728B341.EE98.0025.0@wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox