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 16AD93B775C for ; Fri, 24 Dec 2004 15:43:53 +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 85539-03 for ; Fri, 24 Dec 2004 15:43:46 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id E216C3B77C1 for ; Fri, 24 Dec 2004 15:43:49 +0000 (GMT) Received: from gnari ([157.157.180.107] [157.157.180.107]) by quasar.skima.is with ESMTP; Fri, 24 Dec 2004 15:43:50 Z Subject: Re: Speed in V8.0 From: Ragnar =?ISO-8859-1?Q?Hafsta=F0?= To: Thomas Wegner Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Fri, 24 Dec 2004 15:45:10 +0000 Message-Id: <1103903110.4447.8.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit 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/293 X-Sequence-Number: 9668 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