X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EE3A1329E77 for ; Tue, 19 Oct 2004 23:09:26 +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 30186-05 for ; Tue, 19 Oct 2004 22:09:22 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.194]) by svr1.postgresql.org (Postfix) with ESMTP id 2DA60329E6F for ; Tue, 19 Oct 2004 23:09:24 +0100 (BST) Received: by mproxy.gmail.com with SMTP id 73so393035rnk for ; Tue, 19 Oct 2004 15:09:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=kPiOeanz1JVvEsqk8dIbi4hXLgfuVGjtSHHBc9Fct0Dh6w+sQviztFbsutbBCL+pBpvALABYgHDCArKFqqUJIwaWhkP8LO+0IgyICLPQpse0DSkuOdpVYjrmMFtoBywOBwTaQ9JL2QuXWgepnqNJjwecJC499gfW1b1r1kvroXs Received: by 10.38.152.19 with SMTP id z19mr2207450rnd; Tue, 19 Oct 2004 15:09:21 -0700 (PDT) Received: by 10.38.165.1 with HTTP; Tue, 19 Oct 2004 15:09:21 -0700 (PDT) Message-ID: Date: Tue, 19 Oct 2004 17:09:21 -0500 From: Kevin Barnard Reply-To: Kevin Barnard To: "MikeSmialek2@Hotmail.com" Subject: Re: [PERFORM] Performance on Win32 vs Cygwin Cc: PostgreSQL In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200410/861 X-Sequence-Number: 67384 Have you looked at the 7.3 configuration file vs. the 8.0. It's possible that the 7.3 file is tweakled better then the 8.0. Have you anaylzed the tables after loading the data into 8.0 On Thu, 14 Oct 2004 12:01:38 -0500, MikeSmialek2@Hotmail.com wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >