From: PFC <lists@peufeu.com>
To: Joost Kraaijeveld <J.Kraaijeveld@askesis.nl>
To: David Lang <david@lang.hm>
Cc: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: x206-x225
Date: Sat, 11 Mar 2006 12:33:50 +0100
Message-ID: <op.s58yeob1cigqcu@apollo13> (raw)
In-Reply-To: <1142065029.6634.23.camel@localhost>
References: <GMEAJIDMNDKCIHMMHDFLCEKHDHAA.hjs@rmax.nl>
<441181C6.3040401@archonet.com>
<1142063378.6634.13.camel@localhost>
<Pine.LNX.4.62.0603102355550.23148@qnivq.ynat.uz>
<1142065029.6634.23.camel@localhost>
>> each transaction requires a sync to the disk, a sync requires a real
>> write (which you then wait for), so you can only do one transaction per
>> rotation.
> Not according to a conversation I had with Western Digital about the
It depends if you consider that "written to the disk" means "data is
somewhere between the OS cache and the platter" or "data is writter on the
platter and will survive a power loss".
Postgres wants the second option, of course.
For that, the data has to be on the disk. Thus, the disk has to seek, wait
till the desired sector arrives in front of the head, write, and tell the
OS it's done. Your disk just stores data in its embedded RAM buffer and
tells the OS it's written, but if you lose power, you lose anything that's
in the disk embedded RAM cache...
Advanced RAID cards have battery backed up RAM cache precisely for that
purpose. Your harddisk doesn't.
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@peufeu.com, J.Kraaijeveld@askesis.nl, david@lang.hm, dev@archonet.com
Subject: Re: x206-x225
In-Reply-To: <op.s58yeob1cigqcu@apollo13>
* 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