From: Chris Bowlby <excalibur@hub.org>
To: Ron Johnson <ron.l.johnson@cox.net>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: Hardware recommendations to scale to silly load
Date: Thu, 28 Aug 2003 11:05:17 -0300
Message-ID: <1062079515.88334.24.camel@morpheus> (raw)
In-Reply-To: <1061953146.18108.291.camel@haggis>
References: <1061948112.15800.53.camel@gibraltar.mattclark.net>
<1061953146.18108.291.camel@haggis>
On Tue, 2003-08-26 at 23:59, Ron Johnson wrote:
> What a fun exercises. Ok, lets see:
> Postgres 7.3.4
> RH AS 2.1
> 12GB RAM
> motherboard with 64 bit 66MHz PCI slots
> 4 - Xenon 3.0GHz (1MB cache) CPUs
> 8 - 36GB 15K RPM as RAID10 on a 64 bit 66MHz U320 controller
> having 512MB cache (for database)
> 2 - 36GB 15K RPM as RAID1 on a 64 bit 66MHz U320 controller
> having 512MB cache (for OS, swap, WAL files)
> 1 - library tape drive plugged into the OS' SCSI controller. I
> prefer DLT, but that's my DEC bias.
> 1 - 1000 volt UPS.
Be careful here, we've seen that with the P4 Xeon's that are
hyper-threaded and a system that has very high disk I/O causes the
system to be sluggish and slow. But after disabling the hyper-threading
itself, our system flew..
--
Chris Bowlby <excalibur@hub.org>
Hub.Org Networking Services
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: excalibur@hub.org, ron.l.johnson@cox.net
Subject: Re: Hardware recommendations to scale to silly load
In-Reply-To: <1062079515.88334.24.camel@morpheus>
References: <1061948112.15800.53.camel@gibraltar.mattclark.net> <1061953146.18108.291.camel@haggis> <1062079515.88334.24.camel@morpheus>
* 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