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

Planner problems in 8.2.4 and 8.2.5 (was: Possible plannerbug/regression introduced in 8.2.5)

From: Greg Sabino Mullane <greg(at)turnstep(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Planner problems in 8.2.4 and 8.2.5 (was: Possible plannerbug/regression introduced in 8.2.5)
Date: 2007-11-06 19:27:09
Message-ID: 1194377230.7698.41.camel@greg-laptop (view raw or flat)
Thread:
Lists: pgsql-bugs
I don't have a full test case yet, but I did finally manage to get an
explain analyze to finish in a sane amount of time on 8.2.5. Attached
are two cleaned up explain analyze results, using the exact same data
directory but different executables: one is 8.2.3 and returns as
expected, the other is 8.2.5, which generates a slow plan despite any
fiddling with geqo/join_collapse_limit, etc. The cost is the same, but
it makes a wrong turn partway through the plan. This 8.2.5 has the
earlier patches from Tom already posted applied to it (also tested on
8.2.4 and 8.2.5 with the same result). An earlier version of the query
with tables truncated to 100000 rows ran in 70 seconds on 8.2.3, and did
not finish after an hour on 8.2.5. This version has the tables truncated
to a mere 10000 rows each. The query itself is a view calling some large
views, which call other views and functions, etc. I can post a version
of it if needed, but my energy is mostly focused now on making a
reproducible test case. Now that this is locally reproducible in a
finite amount of time, patches and tweaking suggestions are welcome.
(Postgres built with no special flags from source, all tables have been
analyzed, '***' in the explain analyze plans indicates places manually
made things more readable).


Attachment: 825p_explainanalyze_smaller_pretty
Description: text/plain (3.5 KB)
Attachment: 823_explainanalyze_smaller_pretty
Description: text/plain (3.9 KB)

Responses

pgsql-bugs by date

Next:From: Mason HaleDate: 2007-11-06 19:33:34
Subject: Re: BUG #3724: Duplicate values added to table despite unique index
Previous:From: Kris JurkaDate: 2007-11-06 18:25:11
Subject: Re: BUG #3722: PSQLWarning missing call to super in CTOR

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