X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 21BE65E46CC for ; Fri, 13 Aug 2004 13:06:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01153-10 for ; Fri, 13 Aug 2004 16:06:46 +0000 (GMT) Received: from boutiquenumerique.com (gailleton-2-82-67-9-10.fbx.proxad.net [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id B579F5E46CB for ; Fri, 13 Aug 2004 13:06:37 -0300 (ADT) Received: (qmail 5346 invoked from network); 13 Aug 2004 18:06:44 +0200 Received: from unknown (HELO musicbox) (192.168.0.2) by gailleton-2-82-67-9-10.fbx.proxad.net with SMTP; 13 Aug 2004 18:06:44 +0200 To: pgsql-performance@postgresql.org Subject: Re: fsync vs open_sync References: <6EE64EF3AB31D5448D0007DD34EEB3412A744B@Herge.rcsinc.local> <42528.64.119.142.34.1092244445.squirrel@mail.mohawksoft.com> Message-ID: Date: Fri, 13 Aug 2004 18:06:59 +0200 From: =?iso-8859-15?Q?Pierre-Fr=E9d=E9ric_Caillaud?= Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <42528.64.119.142.34.1092244445.squirrel@mail.mohawksoft.com> User-Agent: Opera M2/7.53 (Linux, build 737) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/214 X-Sequence-Number: 7850 >> 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...