Re: fsync vs open_sync

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: fsync vs open_sync
Date: 2004-08-13 16:06:59
Message-ID: opscohpx2ccq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


>> What caught my attention initially was the 300+/sec insert performance.
>> On 8.0/NTFS/fsync=on, I can't break 100/sec on a 10k rpm ATA disk. My
>> hardware seems to be more or less in the same league as psql's, so I was
>> naturally curious if this was a NT/Unix issue, a 7.4/8.0 issue, or a
>> combination of both.

There is also the fact that NTFS is a very slow filesystem, and Linux is
a lot better than Windows for everything disk, caching and IO related. Try
to copy some files in NTFS and in ReiserFS...

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Pierre-Frédéric Caillaud 2004-08-13 16:12:34 Reiser4
Previous Message Richard Huxton 2004-08-13 15:20:04 Re: Weird Database Performance problem!