pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Anjan Dave <adave@vantage.com>
To: fred@redhotpenguin.com
To: William Yu <wyu@talisys.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Scaling further up
Date: Tue, 2 Mar 2004 13:26:19 -0800
Message-ID: <200403021326.19998.josh@agliodbs.com> (raw)
In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098039@vt-pe2550-001.vantage.vantage.com>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098039@vt-pe2550-001.vantage.vantage.com>

Anjan,

> Question - Are 73GB drives supposed to give better performance because
> of higher number of platters?

Not for your situation, no.   Your issue is random seek times for multiple 
simultaneous seek requests and batched checkpoint updates.   Things that help 
with this are:
More spindles
Better controllers, both RAID and individual disks
Faster drives

Particularly, I'd check out stuff like reports from Tom's Hardware for 
evaluating the real speed of drives and seek times.   Often a really good 
10000 RPM SCSI will beat a 15000RPM SCSI if the latter has poor onboard 
programming.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco




view thread (35+ messages)  latest in thread

Message-ID: <200403021326.19998.josh@agliodbs.com>
Permalink:  ../200403021326.19998.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200403021326.19998.josh@agliodbs.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: josh@agliodbs.com, adave@vantage.com, fred@redhotpenguin.com, wyu@talisys.com
  Subject: Re: Scaling further up
  In-Reply-To: <200403021326.19998.josh@agliodbs.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