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 6F4F0D1B88E for ; Wed, 2 Jun 2004 17:24:47 -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 15562-02 for ; Wed, 2 Jun 2004 20:24:48 +0000 (GMT) Received: from smtp1.actcom.co.il (mx1.actcom.co.il [192.114.47.13]) by svr1.postgresql.org (Postfix) with ESMTP id 7BBB4D1B459 for ; Wed, 2 Jun 2004 17:24:45 -0300 (ADT) Received: from actcom.co.il (actcom.co.il [192.114.47.1]) by smtp1.actcom.co.il (8.12.11/8.12.11) with ESMTP id i52KOKBQ019294; Wed, 2 Jun 2004 23:24:30 +0300 Received: from shemesh.biz by actcom.co.il with ESMTP (8.11.6/actcom-0.3) id i52KOJi00894; Wed, 2 Jun 2004 23:24:19 +0300 (EET DST) (rfc931-sender: line102-130.adsl.actcom.co.il [192.117.102.130]) Message-ID: <40BE3773.1000107@shemesh.biz> Date: Wed, 02 Jun 2004 23:24:19 +0300 From: Shachar Shemesh Organization: Lingnu Open Source Consulting User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040528 Debian/1.6-7 X-Accept-Language: en, he MIME-Version: 1.0 To: Greg Stark Cc: Vitaly Belman , pgsql-performance@postgresql.org, Bryan Encina , Matthew Nuzum Subject: Re: PostgreSQL on VMWare vs Windows vs CoLinux References: <16113857921.20040602015607@012.net.il> <87n03m592f.fsf@stark.xeocode.com> In-Reply-To: <87n03m592f.fsf@stark.xeocode.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/16 X-Sequence-Number: 7074 Greg Stark wrote: >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. > > I havn't tested it, and it's certanly possible. However, please bear in mind that it is also possible that it just gives better performance. The reason this may be possible is that the emulation layer gets the CPU (and other resources) from the OS in bulk, and decides on it's own how to allocate it to the various processes running within the emulation. Inparticular, this "on it's own" is done using the stock Linux kernel. As Postgresql works sufficiently better on Linux than on Windows, this yields better performance. Again - speculation only. Someone should defenitely make sure that no caching takes place where it shouldn't. As a side note, I have had a chance to talk to Dan Aloni (coLinux maintainer) about running PostgreSQL on coLinux. He said that he knows that this particular use is high on people's priority list, but he feels it is totally unsafe to run a production database on alpha grade software. Then again, free software projects being what they are, this is usually what a maintainer would say. Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/