From: Matt Clark <matt@ymogen.net>
To: 'Thomas Wegner' <tomaten@t-online.de>
To: pgsql-performance@postgresql.org
Subject: Re: Speed in V8.0
Date: Fri, 24 Dec 2004 14:52:11 -0000
Message-ID: <014001c4e9c8$266ec0a0$8300a8c0@solent> (raw)
In-Reply-To: <cqaa3l$12im$2@news.hub.org>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: matt@ymogen.net, tomaten@t-online.de
Subject: Re: Speed in V8.0
In-Reply-To: <014001c4e9c8$266ec0a0$8300a8c0@solent>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox