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 E9AED3B75C8 for ; Fri, 24 Dec 2004 14:52:19 +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 70899-02 for ; Fri, 24 Dec 2004 14:52:09 +0000 (GMT) Received: from bayswater1.ymogen.net (unknown [217.27.247.154]) by svr1.postgresql.org (Postfix) with ESMTP id 382283B75B9 for ; Fri, 24 Dec 2004 14:52:12 +0000 (GMT) Received: from solent (unknown [62.232.40.226]) by bayswater1.ymogen.net (Postfix) with ESMTP id E3753A6084; Fri, 24 Dec 2004 14:52:11 +0000 (GMT) Reply-To: From: "Matt Clark" To: "'Thomas Wegner'" , Subject: Re: Speed in V8.0 Date: Fri, 24 Dec 2004 14:52:11 -0000 Organization: Ymogen Ltd Message-ID: <014001c4e9c8$266ec0a0$8300a8c0@solent> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 In-Reply-To: Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/291 X-Sequence-Number: 9666 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=20 > [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of=20 > Thomas Wegner > Sent: 21 December 2004 23:03 > To: pgsql-performance@postgresql.org > Subject: [PERFORM] Speed in V8.0 >=20 >=20 > Hello, i have a problem between V7.4.3 Cygwin and > V8.0RC2 W2K. I have 2 systems: >=20 > 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 >=20 > Both systems use the default postgresql.conf. Now the=20 > problem. I have an (unoptimized, dynamic) query wich was=20 > execute on the production machine over DSL in 2 seconds and=20 > on my develop machine, connected over local LAN, in 119 seconds! >=20 > Whats this? I can not post the query details here public, its=20 > a commercial project. Any first idea? I execute on both=20 > machine the same query with the same database design! > --------------------------------------------- > Thomas Wegner > CabrioMeter - The Weather Plugin for Trillian=20 > http://www.wegner24.de/cabriometer >=20 >=20 >=20 > ---------------------------(end of=20 > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >=20