From: Thomas Wegner
Subject: Re: Speed in V8.0
Date: ,
Msg-id: cqjevi$1jhh$1@news.hub.org
(view: Whole thread, Raw)
In response to: Speed in V8.0  ("Thomas Wegner")
List: pgsql-performance

Tree view

Speed in V8.0  ("Thomas Wegner", )
 Re: Speed in V8.0  ("Matt Clark", )
 Re: Speed in V8.0  (Ragnar Hafstað, )
 Re: Speed in V8.0  ("Thomas Wegner", )
 Re: Speed in V8.0  ("Thomas Wegner", )

Ok, i installed the 7.4.3 on the dev machine under
Cygwin and the was 4 times slower than the V8.
They need 394 seconds. Whats wrong with my dev
machine. There was enough free memory available.
---------------------------------------------
Thomas Wegner
CabrioMeter - The Weather Plugin for Trillian
http://www.wegner24.de/cabriometer

""Matt Clark"" <> schrieb im Newsbeitrag
news:014001c4e9c8$266ec0a0$8300a8c0@solent...
> 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: 
>> [mailto:] On Behalf Of
>> Thomas Wegner
>> Sent: 21 December 2004 23:03
>> To: 
>> 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
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>




pgsql-performance by date:

From: Bruno Wolff III
Date:
Subject: Re: Why so much time difference with a same query/plan?
From: amrit@health2.moph.go.th
Date:
Subject: Low Performance for big hospital server ..