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

Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine. [ with better indenting ]

From: <mallah(at)trade-india(dot)com>
To: <cbbrowne(at)acm(dot)org>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine. [ with better indenting ]
Date: 2003-10-30 14:12:00
Message-ID: 13042.61.16.154.82.1067523120.squirrel@mail.trade-india.com (view raw or flat)
Thread:
Lists: pgsql-performance


> mallah(at)trade-india(dot)com (Rajesh Kumar Mallah) wrote:
>> Can you please have a Look at the below and suggest why it
>> apparently puts 7.3.4 on an infinite loop . the CPU utilisation of the backend running it
>> approches 99%.
>
> What would be useful, for this case, would be to provide the query plan, perhaps via
>
>  EXPLAIN [Big Long Query].
>
> The difference between that EXPLAIN and what you get on 7.4 might be quite interesting.
>
> I would think it quite unlikely that it is truly an "infinite" loop; it is rather more likely
> that the plan winds up being pretty bad and doing something [a bunch of nested loops, maybe?]
> that run longer than your patience will permit.

:-)   ok i will leave it running and try to get it.

Regds
Mallah.





> --
> wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
> http://www3.sympatico.ca/cbbrowne/lsf.html
> Rules of the Evil Overlord #81. "If I am fighting with the hero atop a moving platform, have
> disarmed him, and am about to finish him off and he glances behind  me and drops flat, I too
> will  drop flat instead of quizzically turning around to find out what he saw."
> <http://www.eviloverlord.com/>
>
> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you
> searched our list archives?
>
>               http://archives.postgresql.org



-----------------------------------------
Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/



In response to

Responses

pgsql-performance by date

Next:From: scott.marloweDate: 2003-10-30 14:29:32
Subject: Re: vacuum locking
Previous:From: Bruno Wolff IIIDate: 2003-10-30 14:04:06
Subject: Re: Ignoring index on (A is null), (A is not null) conditions

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