X-Original-To: pgsql-hackers-win32-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D507632B010; Thu, 14 Oct 2004 22:46:11 +0100 (BST) 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 72230-08; Thu, 14 Oct 2004 21:46:02 +0000 (GMT) Received: from hotmail.com (bay10-dav18.bay10.hotmail.com [64.4.37.192]) by svr1.postgresql.org (Postfix) with ESMTP id 2AF6D32B00A; Thu, 14 Oct 2004 22:46:03 +0100 (BST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 14 Oct 2004 14:46:03 -0700 Received: from 199.249.167.148 by BAY10-DAV18.phx.gbl with DAV; Thu, 14 Oct 2004 21:45:55 +0000 X-Originating-IP: [199.249.167.148] X-Originating-Email: [mikesmialek2@hotmail.com] X-Sender: mikesmialek2@hotmail.com From: "MikeSmialek2@Hotmail.com" To: "Magnus Hagander" , , References: <6BCB9D8A16AC4241919521715F4D8BCE475EE5@algol.sollentuna.se> Subject: Re: Performance on Win32 vs Cygwin Date: Thu, 14 Oct 2004 16:45:51 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Message-ID: X-OriginalArrivalTime: 14 Oct 2004 21:46:03.0135 (UTC) FILETIME=[3391B8F0:01C4B237] 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: 200410/70 X-Sequence-Number: 2360 Thanks Magnus, So are we correct to rely on - 8 being slower than 7.x in general and - 8 on Win32 being a little faster than 8 on Cygwin? Will the final release of 8 be faster than the beta? Thanks, Mike ----- Original Message ----- From: "Magnus Hagander" To: "MikeSmialek2@Hotmail.com" ; ; Sent: Thursday, October 14, 2004 12:29 PM Subject: SV: [pgsql-hackers-win32] Performance on Win32 vs Cygwin >Hi, > >We are experiencing slow performance on 8 Beta 2 Dev3 on Win32 and are >trying to determine why. Any info is appreciated. > >We have a Web Server and a DB server both running Win2KServer with all >service packs and critical updates. > >An ASP page on the Web Server hits the DB Server with a simple >query that >returns 205 rows and makes the ASP page delivered to the user >about 350K. > >On an ethernet lan a client pc perceives just under 1 sec >performance with >the following DB Server configuration: > PIII 550Mhz > 256MB RAM > 7200 RPM HD > cygwin > Postgresql 7.1.3 > PGODBC 7.3.2 > >We set up another DB Server with 8 beta (same Web Server, same >network, same >client pc) and now the client pc perceives response of just >over 3 sec with >the following DB server config: > PIII 700 Mhz > 448MB RAM > 7200 RPM HD > 8 Beta 2 Dev3 on Win32 running as a service > >Is the speed decrease because it's a beta? >Is the speed decrease because it's running on Win instead of cygwin? > >We did not install cygwin on the new DB Server. IIRC, previous versions of postgresql (< 8.0) did not correctly sync disks when running on Cygwin. I'm not 100% sure, can someone confirm? 8.0 does, and I beleive it does both under native win32 and cygwin. It's been my experience that the native version is slightly faster than the cygwin one, but I've only compared 8.0 to 8.0. //Magnus