Re: Write ahead logging - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: Write ahead logging
Date
Msg-id d2795vc9bk18269rns92abumarpaukvsqm@4ax.com
Whole thread Raw
In response to Write ahead logging  (Matthias Meixner <meixner@dvs1.informatik.tu-darmstadt.de>)
List pgsql-performance
On Thu, 20 Feb 2003 09:42:02 +0100, Matthias Meixner
<meixner@dvs1.informatik.tu-darmstadt.de> wrote:
>Using a slow disk (5400rpm) I measured about 3-5 ms for a commit. But
>average rotational delay is already higher for that disk (5.5ms).
>So the question is: has anybody verified, that the log is written to disk
>before returning from commit?

Some (or all?) IDE disks are known to lie:  they report success as
soon as the data have reached the drive's RAM.

Servus
 Manfred

pgsql-performance by date:

Previous
From: Matthias Meixner
Date:
Subject: Write ahead logging
Next
From: "Mario Weilguni"
Date:
Subject: Re: Write ahead logging