| From: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: x206-x225 |
| Date: | 2006-03-11 07:49:38 |
| Message-ID: | 1142063378.6634.13.camel@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Fri, 2006-03-10 at 13:40 +0000, Richard Huxton wrote:
> Your ATA disk is lying about disk caching being turned off. Assuming
> each insert is in a separate transaction, then it's not going to do
> 10,000 / 6 = 1667 transactions/sec - that's faster than it's rotational
> speed.
Could you explain the calculation? Why should the number of transactions
be related to the rotational speed of the disk, without saying anything
about the number of bytes per rotation?
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Lang | 2006-03-11 07:57:16 | Re: x206-x225 |
| Previous Message | Chris Travers | 2006-03-11 06:14:15 | Re: firebird X postgresql 8.1.2 windows, performance comparison |