Re: How to improve db performance with $7K?

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Alex Turner" <armtuk(at)gmail(dot)com>, "Kevin Brown" <kevin(at)sysexperts(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: How to improve db performance with $7K?
Date: 2005-04-15 10:13:59
Message-ID: op.so9qplulth1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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)...

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2005-04-15 10:22:52 Re: Foreign key slows down copy/insert
Previous Message PFC 2005-04-15 10:07:43 Re: How to improve db performance with $7K?