pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andreas Pflug <pgadmin@pse-consulting.de>
To: Qingqing Zhou <zhouqq@cs.toronto.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Open request for benchmarking input
Date: Sun, 27 Nov 2005 00:12:01 +0000
Message-ID: <4388F9D1.6080609@pse-consulting.de> (raw)
In-Reply-To: <dmab5n$226n$1@news.hub.org>
References: <Pine.LNX.4.64.0511261025140.16022@discord.dyndns.org>
	<dmab5n$226n$1@news.hub.org>

Qingqing Zhou wrote:
> "Jeff Frost" <jeff@frostconsultingllc.com> wrote

>> "The hardware I have available is as follows:
>>
>>    * 2x dual Opteron 8G ram, 2x144G 15Krpm SCSI
>>    * 2x dual Opteron 8G ram, 2x72G 15Krpm SCSI
>>    * 1x dual Opteron 16G ram, 2x36G 15Krpm SCSI 16x400G 7200rpm SATA
>>
> (2) The hardware configuration may not reflect all potentials of PostgreSQL. 

These boxes don't look like being designed for a DB server. The first 
are very CPU bound, and the third may be a good choice for very large 
amounts of streamed data, but not optimal for TP random access.

Hopefully, when publicly visible benchmarks are performed, machines are 
used that comply with common engineering knowledge, ignoring those guys 
who still believe that sequential performance is the most important 
issue on disk subsystems for DBMS.

Regards,
Andreas



view thread (11+ messages)  latest in thread

Message-ID: <4388F9D1.6080609@pse-consulting.de>
Permalink:  ../4388F9D1.6080609@pse-consulting.de/
Also on:    postgresql.org/message-id/4388F9D1.6080609@pse-consulting.de

 · 

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: pgadmin@pse-consulting.de, zhouqq@cs.toronto.edu
  Subject: Re: Open request for benchmarking input
  In-Reply-To: <4388F9D1.6080609@pse-consulting.de>

* 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