Re: Write ahead logging

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Matthias Meixner <meixner(at)dvs1(dot)informatik(dot)tu-darmstadt(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Write ahead logging
Date: 2003-02-20 09:17:31
Message-ID: d2795vc9bk18269rns92abumarpaukvsqm@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 20 Feb 2003 09:42:02 +0100, Matthias Meixner
<meixner(at)dvs1(dot)informatik(dot)tu-darmstadt(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mario Weilguni 2003-02-20 09:27:46 Re: Write ahead logging
Previous Message Matthias Meixner 2003-02-20 08:42:02 Write ahead logging