pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alan Stange <stange@rentec.com>
To: Luke Lonergan <llonergan@greenplum.com>
Cc: Dave Cramer <pg@fastcrypt.com>
Cc: Greg Stark <gsstark@mit.edu>
Cc: Joshua Marsh <icub3d@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware/OS recommendations for large databases (
Date: Fri, 18 Nov 2005 14:39:50 -0500
Message-ID: <437E2E06.5070306@rentec.com> (raw)
In-Reply-To: <BFA362F3.14099%llonergan@greenplum.com>
References: <BFA362F3.14099%llonergan@greenplum.com>

Luke Lonergan wrote:
>> opterons from Sun that we got some time ago.   I think the 130MB/s is
>> slow given the hardware, but it's acceptable.  I'm not too price
>> sensitive; I care much more about reliability, uptime, etc.
>>     
> I don't know what the system cost. It was part of block of dual
>
> Then I know what they cost - we have them too (V20z and V40z).  You should
> be getting 400MB/s+ with external RAID.
Yes, but we don't.   This is where I would normally begin a rant on how 
craptacular Linux can be at times.  But, for the sake of this 
discussion, postgresql isn't reading the data any more slowly than does 
any other program.

And we don't have the time to experiment with the box.

I know it should be better, but it's good enough for our purposes at 
this time.

-- Alan




view thread (173+ messages)  latest in thread

Message-ID: <437E2E06.5070306@rentec.com>
Permalink:  ../437E2E06.5070306@rentec.com/
Also on:    postgresql.org/message-id/437E2E06.5070306@rentec.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: stange@rentec.com, llonergan@greenplum.com, pg@fastcrypt.com, gsstark@mit.edu, icub3d@gmail.com
  Subject: Re: Hardware/OS recommendations for large databases (
  In-Reply-To: <437E2E06.5070306@rentec.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