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 7755BD1B1AE for ; Wed, 2 Jun 2004 18:31:24 -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 45136-05 for ; Wed, 2 Jun 2004 21:31:25 +0000 (GMT) Received: from gpdnet.co.uk (gpdnet.plus.com [212.56.100.243]) by svr1.postgresql.org (Postfix) with ESMTP id 8C277D1B1BD for ; Wed, 2 Jun 2004 18:31:19 -0300 (ADT) Received: from gary (unverified [192.168.1.2]) by gpdnet.co.uk (SurgeMail 1.8g3) with ESMTP id 226 for ; Wed, 02 Jun 2004 23:31:58 +0100 From: "Gary Doades" To: Date: Wed, 02 Jun 2004 22:31:27 +0100 MIME-Version: 1.0 Subject: Re: PostgreSQL on VMWare vs Windows vs CoLinux Message-ID: <40BE553F.32703.10C5956B@localhost> In-reply-to: <6EE64EF3AB31D5448D0007DD34EEB34101AE4A@Herge.rcsinc.local> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Server: High Performance Mail Server - http://surgemail.com X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/20 X-Sequence-Number: 7078 On 2 Jun 2004 at 16:45, Merlin Moncure wrote: > > 'better' does not mean 'faster'. Win32 has a pretty decent journaling > filesytem (ntfs) and a good I/O subsystem which includes IPC. Process > management is poor compared to newer linux kernels but this is > unimportant except in extreme cases. Right now the win32 native does > not sync() (but does fsync()). So, the performance is somewhere between > fsync = off and fsync = on (probably much closer to fsync = on). It is > reasonable to assume that the win32 port will outperform the unix > versions at many tasks (at the expense of safety) until the new sync() > code is put in. > > If tested on the same source base, 40-60% differences can only be coming > from the I/O subsystem. There are other factors which aren't clear from > this exchange like what version of gcc, etc. > Hmm, interesting. I've been running the Win32 port for a couple of weeks now. Using the same database as a Linux 2.6 system. Same processor and memory but different disks. Linux system has 10K rpm SCSI disks Windows has 7200 rpm serial ATA disks. When a lot of IO is involved the performance differences are very mixed as I would expect. Sometimes Windows wins, sometimes Linux. BUT, very consistently, when NO IO is involved then the Win32 port is always around 20% slower than Linux. In cases where the EXPLAIN ANALYZE results are different I have disregarded. In all the cases that the EXPLAIN ANALYZE results are the same and no IO is involved the Win32 port is slower. Currently I am putting this down to the build/gcc differences. I can't see why there should be this difference otherwise. (memory management??) Regards, Gary.