Re: Write ahead logging

From: "Mario Weilguni" <mweilguni(at)sime(dot)com>
To: "Manfred Koizar" <mkoi-pg(at)aon(dot)at>, "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:27:46
Message-ID: 000b01c2d8c2$54008350$8f01c00a@icomedias.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

under linux, hdparm -W can turn off the write cache of IDE disk, maybe you
should try with write-caching turned off.

best regards,
mario weilguni

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Manfred Koizar 2003-02-20 10:00:19 Re: cost and actual time
Previous Message Manfred Koizar 2003-02-20 09:17:31 Re: Write ahead logging