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 EA6FBD1B18C for ; Wed, 2 Jun 2004 12:25:46 -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 79341-07 for ; Wed, 2 Jun 2004 15:25:44 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 41F20D1CE38 for ; Wed, 2 Jun 2004 12:25:43 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i52FOtFR024745; Wed, 2 Jun 2004 11:24:55 -0400 (EDT) To: Greg Stark Cc: Vitaly Belman , pgsql-performance@postgresql.org, Bryan Encina , Matthew Nuzum Subject: Re: PostgreSQL on VMWare vs Windows vs CoLinux In-reply-to: <87n03m592f.fsf@stark.xeocode.com> References: <16113857921.20040602015607@012.net.il> <87n03m592f.fsf@stark.xeocode.com> Comments: In-reply-to Greg Stark message dated "02 Jun 2004 10:27:36 -0400" Date: Wed, 02 Jun 2004 11:24:55 -0400 Message-ID: <24744.1086189895@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/10 X-Sequence-Number: 7068 Greg Stark writes: > That said, I'm curious why the emulated servers performed better than the > Native Windows port. My first thought is that they probably aren't syncing > every write to disk so effectively they're defeating the fsyncs, allowing the > host OS to buffer disk writes. It would be fairly easy to check this by repeating the comparisons with fsync = off in postgresql.conf. A performance number that doesn't change much would be a smoking gun ;-). The native port hasn't had any performance testing done on it yet, and I wouldn't be surprised to hear of a gotcha or two. Perhaps with the recent schedule change there will be some time for performance tuning before we go beta. regards, tom lane