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 1199F3A6D16 for ; Sat, 25 Dec 2004 13:28:52 +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 92747-04 for ; Sat, 25 Dec 2004 13:28:42 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id DB4043CCCF7 for ; Sat, 25 Dec 2004 13:28:44 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id E7CED31952; Sat, 25 Dec 2004 14:28:44 +0100 (MET) From: "Thomas Wegner" X-Newsgroups: pgsql.performance Subject: Re: Speed in V8.0 Date: Sat, 25 Dec 2004 14:28:41 +0100 Organization: Hub.Org Networking Services Lines: 42 Message-ID: References: <1103903110.4447.8.camel@localhost.localdomain> 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; Original 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/309 X-Sequence-Number: 9684 Thats was it. Now the speed was ok. Thank you. --------------------------------------------- Thomas Wegner CabrioMeter - The Weather Plugin for Trillian http://www.wegner24.de/cabriometer "Ragnar "Hafstaš"" schrieb im Newsbeitrag news:1103903110.4447.8.camel@localhost.localdomain... > On Wed, 2004-12-22 at 00:03 +0100, Thomas Wegner wrote: >> 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! > > has the development database been ANALYZED ? > > gnari > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html >