| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-08-28 14:13:21 | Re: Index creation takes for ever |
| Previous Message | Tom Lane | 2003-08-28 13:58:00 | Re: suspicous looking code in copy.c |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-08-28 14:23:13 | Re: Hardware recommendations to scale to silly load |
| Previous Message | Tomka Gergely | 2003-08-28 13:45:42 | Re: The results of my PostgreSQL/filesystem performance |