pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: MikeSmialek2@Hotmail.com <mikesmialek2@hotmail.com>
To: pgsql-performance@postgresql.org
To: pgsql-hackers-win32@postgresql.org
Subject: Performance on Win32 vs Cygwin
Date: Thu, 14 Oct 2004 12:01:38 -0500
Message-ID: <BAY10-DAV143SOlbpH7000236a9@hotmail.com> (raw)

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






view thread (8+ messages)  latest in thread

Message-ID: <BAY10-DAV143SOlbpH7000236a9@hotmail.com>
Permalink:  ../BAY10-DAV143SOlbpH7000236a9@hotmail.com/
Also on:    postgresql.org/message-id/BAY10-DAV143SOlbpH7000236a9@hotmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: mikesmialek2@hotmail.com, pgsql-hackers-win32@postgresql.org
  Subject: Re: Performance on Win32 vs Cygwin
  In-Reply-To: <BAY10-DAV143SOlbpH7000236a9@hotmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox