From: James Thornton <james@jamesthornton.com>
To: Bjoern Metzdorf <bm@turtle-entertainment.de>
Cc: pgsql-performance@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [PERFORM] Quad processor options - summary
Date: Thu, 13 May 2004 16:02:08 -0500
Message-ID: <40A3E250.2020204@jamesthornton.com> (raw)
In-Reply-To: <40A2A7FA.6060403@turtle-entertainment.de>
References: <Pine.LNX.4.33.0405120741190.25767-100000@css120.ihs.com>
<40A2A7FA.6060403@turtle-entertainment.de>
Bjoern Metzdorf wrote:
> Hi,
>
> at first, many thanks for your valuable replies. On my quest for the
> ultimate hardware platform I'll try to summarize the things I learned.
>
> -------------------------------------------------------------
> This is what I am considering the ultimate platform for postgresql:
>
> Hardware:
> Tyan Thunder K8QS board
> 2-4 x Opteron 848 in NUMA mode
> 4-8 GB RAM (DDR400 ECC Registered 1 GB modules, 2 for each processor)
> LSI Megaraid 320-2 with 256 MB cache ram and battery backup
> 6 x 36GB SCSI 10K drives + 1 spare running in RAID 10, split over both
> channels (3 + 4) for pgdata including indexes and wal.
You might also consider configuring the Postgres data drives for a RAID
10 SAME configuration as described in the Oracle paper "Optimal Storage
Configuration Made Easy"
(http://otn.oracle.com/deploy/availability/pdf/oow2000_same.pdf). Has
anyone delved into this before?
--
James Thornton
______________________________________________________
Internet Business Consultant, http://jamesthornton.com
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: james@jamesthornton.com, bm@turtle-entertainment.de, pgsql-admin@postgresql.org
Subject: Re: [PERFORM] Quad processor options - summary
In-Reply-To: <40A3E250.2020204@jamesthornton.com>
* 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