pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (8+ messages)  latest in thread

Message-ID: <40A3E250.2020204@jamesthornton.com>
Permalink:  ../40A3E250.2020204@jamesthornton.com/
Also on:    postgresql.org/message-id/40A3E250.2020204@jamesthornton.com

 · 

reply

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