From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine. [ with better indenting ]
Date: Thu, 30 Oct 2003 10:10:47 -0500
Message-ID: <m3smlaiww8.fsf@wolfe.cbbrowne.com> (raw)
References: <33298.203.145.130.142.1067457626.squirrel@mail.trade-india.com>
<20031029202920.GZ7337@pallas.fsck.com>
<33402.203.145.130.142.1067460429.squirrel@mail.trade-india.com>
<200310301702.00275.mallah@trade-india.com>
<m33cdakhv7.fsf@wolfe.cbbrowne.com>
<13042.61.16.154.82.1067523120.squirrel@mail.trade-india.com>
In the last exciting episode, mallah@trade-india.com wrote:
>> mallah@trade-india.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.
No, if you just do EXPLAIN (and not EXPLAIN ANALYZE), that returns
without executing the query.
If the query runs for a really long time, then we _know_ that there is
something troublesome. EXPLAIN (no ANALYZE) should provide some
insight without having anything run for a long time.
If EXPLAIN [big long query] turns into what you are terming an
"infinite loop," then you have a quite different problem, and it would
be very useful to know that.
--
"cbbrowne","@","ntlug.org"
http://www3.sympatico.ca/cbbrowne/oses.html
This is Linux country. On a quiet night, you can hear NT re-boot.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine. [ with better indenting ]
In-Reply-To: <m3smlaiww8.fsf@wolfe.cbbrowne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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