Postgres Pro
Downloads
Home   >   mailing lists

Re: Possible planner bug/regression introduced in 8.2.5 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Possible planner bug/regression introduced in 8.2.5
Date
Msg-id 1549.1193232434@sss.pgh.pa.us
Whole thread Raw
In response to Possible planner bug/regression introduced in 8.2.5  (Jakub Ouhrabka <kuba@comgate.cz>)
Responses Re: Possible planner bug/regression introduced in 8.2.5
List pgsql-bugs
Tree view 
Jakub Ouhrabka <kuba@comgate.cz> writes:
> I tried to simplify the query even more and now I have query which on
> 8.2.4 is planned instantly and on 8.2.5 takes cca 8 seconds.

Are you sure you were using the same planner parameters (particularly
join_collapse_limit and the geqo threshold) in both cases?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bill Moran
Date:
Subject: Re: BUG #3692: Conflicting create table statements throw unexpected error
Next
From: Jakub Ouhrabka
Date:
Subject: Re: Possible planner bug/regression introduced in 8.2.5