Re: win32 performance - fsync question

From: Evgeny Rodichev <er(at)sai(dot)msu(dot)su>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Magnus Hagander <mha(at)sollentuna(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: win32 performance - fsync question
Date: 2005-02-17 19:54:22
Message-ID: Pine.GSO.4.62.0502172242520.23498@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 17 Feb 2005, Tom Lane wrote:

> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
>>> WinXP fsync = true 20-28 tps
>>> WinXP fsync = false 600 tps
>>> Linux fsync = true 800 tps
>>> Linux fsync = false 980 tps
>
>> Wow, that's terrible on Windows. If there's a solution, it'd be nice to
>> backport it...
>
> Actually, the number that's way out of line there is the Linux w/fsync
> one. I infer that he's got disk write cache enabled and therefore the
> transactions aren't really being synced to disk at all.
>
> Any claimed TPS rate exceeding your disk drive's rotation rate is a
> red flag.

Write cache is enabled under Linux by default all the time I make deal
with it (since 1993).

It doesn't interfere with fsync(), as linux kernel uses cache flush for
fsync.

I have 2.6.10 kernel running *without* any additional patches, and without
any specific hdparm settings.

fsync() really works fine as I switch off my notebook everyday 2-3 times,
and never had any data loss :)

Related staff from dmesg is

hda: cache flushes supported

Regards,
E.R.
_________________________________________________________________________
Evgeny Rodichev Sternberg Astronomical Institute
email: er(at)sai(dot)msu(dot)su Moscow State University
Phone: 007 (095) 939 2383
Fax: 007 (095) 932 8841 http://www.sai.msu.su/~er

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-02-17 20:01:09 Re: win32 performance - fsync question
Previous Message Merlin Moncure 2005-02-17 19:54:21 Re: win32 performance - fsync question