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 990463ABD2E for ; Wed, 22 Dec 2004 00:25:54 +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 58693-01 for ; Wed, 22 Dec 2004 00:25:47 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 026273ABD19 for ; Wed, 22 Dec 2004 00:25:47 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id E6D3831971; Wed, 22 Dec 2004 01:25:47 +0100 (MET) From: "Thomas Wegner" X-Newsgroups: pgsql.performance Subject: Re: Speed in V8.0 Date: Wed, 22 Dec 2004 01:25:45 +0100 Organization: Hub.Org Networking Services Lines: 44 Message-ID: References: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-RFC2646: Format=Flowed; Response X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 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/289 X-Sequence-Number: 9664 2. Develop Machine - P4 1800MHz - 760 MB RAM - W2K - PostgreSQL 8.0 RC2 Native Windows - local connection 100MB/FD --------------------------------------------- Thomas Wegner CabrioMeter - The Weather Plugin for Trillian http://www.wegner24.de/cabriometer "Thomas Wegner" schrieb im Newsbeitrag news:cqaa3l$12im$2@news.hub.org... > 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 > >