Skip site navigation (1) Skip section navigation (2)

Re: 7.4 dramatically slower than 7.3?

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>,pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: 7.4 dramatically slower than 7.3?
Date: 2004-04-06 15:36:21
Message-ID: 4072CE75.3030907@e-trolley.de (view raw or flat)
Thread:
Lists: pgsql-novice
Stephan Szabo wrote:

> One other possibility is that the planning is taking a really long time.
> How long do explain (non-analyze) on the two systems take?  And how many
> joins are there precisely?

Yeah, that seems to be it.
It takes ~
(real) 3.776s on 7.4
(real) 0.082s on 7.3
measured with bash/time but shouldn't make a difference

So the plan is actually better but takes much longer to ... plan, right?

-- 
  e-Trolley Sayegh & John, Nabil Sayegh
  Tel.: 0700 etrolley /// 0700 38765539
  Fax.: +49 69 8299381-8
  PGP : http://www.e-trolley.de

In response to

Responses

pgsql-novice by date

Next:From: Stephan SzaboDate: 2004-04-06 16:21:45
Subject: Re: 7.4 dramatically slower than 7.3?
Previous:From: George WeaverDate: 2004-04-06 15:26:59
Subject: Re: dotnet stored procedures with postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group