pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PFC <lists@boutiquenumerique.com>
To: Alex Turner <armtuk@gmail.com>
To: Kevin Brown <kevin@sysexperts.com>
To: pgsql-performance@postgresql.org
Subject: Re: How to improve db performance with $7K?
Date: Fri, 15 Apr 2005 12:13:59 +0200
Message-ID: <op.so9qplulth1vuj@localhost> (raw)
In-Reply-To: <33c6269f050414192472a58cf6@mail.gmail.com>
References: <d31f71$2epm$1@news.hub.org>
	<33c6269f050414192472a58cf6@mail.gmail.com>
	<20050415020337.GD19518@filer>
	<446.1113489854@sss.pgh.pa.us>
	<20050414083608.GC19518@filer>
	<878y3lj23o.fsf@stark.xeocode.com>
	<20050414055655.GB19518@filer>
	<13449.1112847297@sss.pgh.pa.us>
	<87wtrfmgt5.fsf@stark.xeocode.com>
	<33c6269f0504061732195f6ae4@mail.gmail.com>
	<20050406224102.GM93835@decibel.org>



> platter compared to the rotational speed, which would agree with the
> fact that you can read 70MB/sec, but it takes up to 13ms to seek.

	Actually :
	- the head has to be moved
	this time depends on the distance, for instance moving from a cylinder to  
the next is very fast (it needs to, to get good throughput)
	- then you have to wait for the disk to spin until the information you  
want comes in front of the head... statistically you have to wait a half  
rotation. And this does not depend on the distance between the cylinders,  
it depends on the position of the data in the cylinder.
	The more RPMs you have, the less you wait, which is why faster RPMs  
drives have faster seek (they must also have faster actuators to move the  
head)...



view thread (119+ messages)  latest in thread

Message-ID: <op.so9qplulth1vuj@localhost>
Permalink:  ../op.so9qplulth1vuj@localhost/
Also on:    postgresql.org/message-id/op.so9qplulth1vuj@localhost

 · 

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: lists@boutiquenumerique.com, armtuk@gmail.com, kevin@sysexperts.com
  Subject: Re: How to improve db performance with $7K?
  In-Reply-To: <op.so9qplulth1vuj@localhost>

* 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