Performance on Win32 vs Cygwin

From: "MikeSmialek2(at)Hotmail(dot)com" <mikesmialek2(at)hotmail(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>, <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Performance on Win32 vs Cygwin
Date: 2004-10-14 17:01:38
Message-ID: BAY10-DAV143SOlbpH7000236a9@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers-win32 pgsql-performance

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.

Thanks,

Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steven Klassen 2004-10-14 17:07:39 Re: Verifying a user.
Previous Message Michael Fuhr 2004-10-14 16:56:10 Re: Verifying a user.

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Magnus Hagander 2004-10-14 17:29:25 Re: Performance on Win32 vs Cygwin
Previous Message Albi Rebmann 2004-10-14 12:25:38 Re: postgres win32 in FAT32

Browse pgsql-performance by date

  From Date Subject
Next Message Magnus Hagander 2004-10-14 17:29:25 Re: Performance on Win32 vs Cygwin
Previous Message Jan Wieck 2004-10-14 04:29:19 Re: First set of OSDL Shared Mem scalability results, some