Skip site navigation (1) Skip section navigation (2)

Re: Hardware recommendations to scale to silly load

From: Chris Bowlby <excalibur(at)hub(dot)org>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hardware recommendations to scale to silly load
Date: 2003-08-28 14:05:17
Message-ID: 1062079515.88334.24.camel@morpheus (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
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(at)hub(dot)org>
Hub.Org Networking Services


In response to

Responses

pgsql-performance by date

Next:From: Shridhar DaithankarDate: 2003-08-28 14:23:13
Subject: Re: Hardware recommendations to scale to silly load
Previous:From: Tomka GergelyDate: 2003-08-28 13:45:42
Subject: Re: The results of my PostgreSQL/filesystem performance

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-08-28 14:13:21
Subject: Re: Index creation takes for ever
Previous:From: Tom LaneDate: 2003-08-28 13:58:00
Subject: Re: suspicous looking code in copy.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group