pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jacques Caron <jc@directinfos.com>
To: Alex Turner <armtuk@gmail.com>
Cc: Greg Stark <gsstark@mit.edu>
Cc: William Yu <wyu@talisys.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to improve db performance with $7K?
Date: Mon, 18 Apr 2005 20:24:25 +0200
Message-ID: <6.2.0.14.0.20050418202039.03f12008@wheresmymailserver.com> (raw)
In-Reply-To: <33c6269f05041811165228c814@mail.gmail.com>
References: <CC74E7E10A8A054798B6611BD1FEF4D30625DA5B@vamail01.thexchange.com>
	<425EBA0C.6030804@sfnet.cc>
	<d3vpnn$2iu$1@news.hub.org>
	<87pswsku6e.fsf@stark.xeocode.com>
	<33c6269f0504180817511b27a3@mail.gmail.com>
	<878y3gks3p.fsf@stark.xeocode.com>
	<33c6269f05041809566abf91d2@mail.gmail.com>
	<6.2.0.14.0.20050418192528.04238088@pop.interactivemediafactory.net>
	<33c6269f05041811165228c814@mail.gmail.com>

Hi,

At 20:16 18/04/2005, Alex Turner wrote:
>So my assertion that adding more drives doesn't help is pretty
>wrong... particularly with OLTP because it's always dealing with
>blocks that are smaller that the stripe size.

When doing random seeks (which is what a database needs most of the time), 
the number of disks helps improve the number of seeks per second (which is 
the bottleneck in this case). When doing sequential reads, the number of 
disks helps improve total throughput (which is the bottleneck in that case).

In short: in always helps :-)

Jacques.





view thread (119+ messages)  latest in thread

Message-ID: <6.2.0.14.0.20050418202039.03f12008@wheresmymailserver.com>
Permalink:  ../6.2.0.14.0.20050418202039.03f12008@wheresmymailserver.com/
Also on:    postgresql.org/message-id/6.2.0.14.0.20050418202039.03f12008@wheresmymailserver.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: jc@directinfos.com, armtuk@gmail.com, gsstark@mit.edu, wyu@talisys.com
  Subject: Re: How to improve db performance with $7K?
  In-Reply-To: <6.2.0.14.0.20050418202039.03f12008@wheresmymailserver.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