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 0AD5A3CC69F for ; Sat, 25 Dec 2004 10:21:50 +0000 (GMT) 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 52056-02 for ; Sat, 25 Dec 2004 10:21:41 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 32AC13CC685 for ; Sat, 25 Dec 2004 10:21:42 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 6E7B331952; Sat, 25 Dec 2004 11:21:42 +0100 (MET) From: "Thomas Wegner" X-Newsgroups: pgsql.performance Subject: Re: Speed in V8.0 Date: Sat, 25 Dec 2004 11:21:39 +0100 Organization: Hub.Org Networking Services Lines: 76 Message-ID: References: <014001c4e9c8$266ec0a0$8300a8c0@solent> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.185 tagged_above=0 required=5 tests=PRIORITY_NO_NAME X-Spam-Level: * X-Archive-Number: 200412/310 X-Sequence-Number: 9685 Ok, i installed the 7.4.3 on the dev machine under Cygwin and the was 4 times slower than the V8. They need 394 seconds. Whats wrong with my dev machine. There was enough free memory available. --------------------------------------------- Thomas Wegner CabrioMeter - The Weather Plugin for Trillian http://www.wegner24.de/cabriometer ""Matt Clark"" schrieb im Newsbeitrag news:014001c4e9c8$266ec0a0$8300a8c0@solent... > Another man working to the bitter end this Christmas! > > There could be many reasons, but maybe first you should look at the amount > of RAM available? If the tables fit in RAM on the production server but > not > on the dev server, then that will easily defeat the improvement due to > using > the native DB version. > > Why don't you install cygwin on the dev box and do the comparison using > the > same hardware? > > M > >> -----Original Message----- >> From: pgsql-performance-owner@postgresql.org >> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of >> Thomas Wegner >> Sent: 21 December 2004 23:03 >> To: pgsql-performance@postgresql.org >> Subject: [PERFORM] Speed in V8.0 >> >> >> Hello, i have a problem between V7.4.3 Cygwin and >> V8.0RC2 W2K. I have 2 systems: >> >> 1. Production Machine >> - Dual P4 3000MHz >> - 2 GB RAM >> - W2K >> - PostgreSQL 7.4.3 under Cygwin >> - i connect to it over a DSL Line >> 2. Develop Machine >> - P4 1800MHz >> - 760 MB RAM >> - PostgreSQL Native Windows >> - local connection 100MB/FD >> >> Both systems use the default postgresql.conf. Now the >> problem. I have an (unoptimized, dynamic) query wich was >> execute on the production machine over DSL in 2 seconds and >> on my develop machine, connected over local LAN, in 119 seconds! >> >> Whats this? I can not post the query details here public, its >> a commercial project. Any first idea? I execute on both >> machine the same query with the same database design! >> --------------------------------------------- >> Thomas Wegner >> CabrioMeter - The Weather Plugin for Trillian >> http://www.wegner24.de/cabriometer >> >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 4: Don't 'kill -9' the postmaster >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend >