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: (view raw or whole 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.


> --
> wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','').
> 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."
> <>
> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you
> searched our list archives?

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.

In response to


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-2015 The PostgreSQL Global Development Group