pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSpeed in V8.0
6+ messages / 3 participants
[nested] [flat]
* Speed in V8.0
@ 2004-12-21 23:03 Thomas Wegner <tomaten@t-online.de>
2004-12-22 00:25 ` Re: Speed in V8.0 Thomas Wegner <tomaten@t-online.de>
2004-12-24 14:52 ` Re: Speed in V8.0 Matt Clark <matt@ymogen.net>
2004-12-24 15:45 ` Re: Speed in V8.0 Ragnar Hafstað <gnari@simnet.is>
0 siblings, 3 replies; 6+ messages in thread
From: Thomas Wegner @ 2004-12-21 23:03 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Speed in V8.0
2004-12-21 23:03 Speed in V8.0 Thomas Wegner <tomaten@t-online.de>
@ 2004-12-22 00:25 ` Thomas Wegner <tomaten@t-online.de>
2 siblings, 0 replies; 6+ messages in thread
From: Thomas Wegner @ 2004-12-22 00:25 UTC (permalink / raw)
To: pgsql-performance
2. Develop Machine
- P4 1800MHz
- 760 MB RAM
- W2K
- PostgreSQL 8.0 RC2 Native Windows
- local connection 100MB/FD
---------------------------------------------
Thomas Wegner
CabrioMeter - The Weather Plugin for Trillian
http://www.wegner24.de/cabriometer
"Thomas Wegner" <tomaten@t-online.de> schrieb im Newsbeitrag
news:cqaa3l$12im$2@news.hub.org...
> 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
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Speed in V8.0
2004-12-21 23:03 Speed in V8.0 Thomas Wegner <tomaten@t-online.de>
@ 2004-12-24 14:52 ` Matt Clark <matt@ymogen.net>
2004-12-25 10:21 ` Re: Speed in V8.0 Thomas Wegner <tomaten@t-online.de>
2 siblings, 1 reply; 6+ messages in thread
From: Matt Clark @ 2004-12-24 14:52 UTC (permalink / raw)
To: 'Thomas Wegner' <tomaten@t-online.de>; pgsql-performance
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Speed in V8.0
2004-12-21 23:03 Speed in V8.0 Thomas Wegner <tomaten@t-online.de>
2004-12-24 14:52 ` Re: Speed in V8.0 Matt Clark <matt@ymogen.net>
@ 2004-12-25 10:21 ` Thomas Wegner <tomaten@t-online.de>
0 siblings, 0 replies; 6+ messages in thread
From: Thomas Wegner @ 2004-12-25 10:21 UTC (permalink / raw)
To: pgsql-performance
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"" <matt@ymogen.net> 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: 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
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Speed in V8.0
2004-12-21 23:03 Speed in V8.0 Thomas Wegner <tomaten@t-online.de>
@ 2004-12-24 15:45 ` Ragnar Hafstað <gnari@simnet.is>
2004-12-25 13:28 ` Re: Speed in V8.0 Thomas Wegner <tomaten@t-online.de>
2 siblings, 1 reply; 6+ messages in thread
From: Ragnar Hafstað @ 2004-12-24 15:45 UTC (permalink / raw)
To: Thomas Wegner <tomaten@t-online.de>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Speed in V8.0
2004-12-21 23:03 Speed in V8.0 Thomas Wegner <tomaten@t-online.de>
2004-12-24 15:45 ` Re: Speed in V8.0 Ragnar Hafstað <gnari@simnet.is>
@ 2004-12-25 13:28 ` Thomas Wegner <tomaten@t-online.de>
0 siblings, 0 replies; 6+ messages in thread
From: Thomas Wegner @ 2004-12-25 13:28 UTC (permalink / raw)
To: pgsql-performance
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ð"" <gnari@simnet.is> 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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2004-12-25 13:28 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-21 23:03 Speed in V8.0 Thomas Wegner <tomaten@t-online.de>
2004-12-22 00:25 ` Thomas Wegner <tomaten@t-online.de>
2004-12-24 14:52 ` Matt Clark <matt@ymogen.net>
2004-12-25 10:21 ` Thomas Wegner <tomaten@t-online.de>
2004-12-24 15:45 ` Ragnar Hafstað <gnari@simnet.is>
2004-12-25 13:28 ` Thomas Wegner <tomaten@t-online.de>
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