Hi,
we switched from 8.2.4 to 8.2.5 and were forced to switch back. Our main
goal was to improve planner perfomance with outer joins per this change
from release notes:
Fix some planner problems with outer joins, notably poor size estimation
for t1 LEFT JOIN t2 WHERE t2.col IS NULL (Tom)
B
In response to Alvaro Herrera <[EMAIL PROTECTED]>:
> Bill Moran wrote:
> > In response to Tom Lane <[EMAIL PROTECTED]>:
> >
> > > "Bill Moran" <[EMAIL PROTECTED]> writes:
> > > > Issuing a statement like:
> > > > CREATE TABLE table2 AS SELECT * FROM table1;
> > > > simultaneously in two separate
Jakub Ouhrabka <[EMAIL PROTECTED]> 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 bo
Hi Tom,
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?
thanks for the reply.
Y
Jakub Ouhrabka <[EMAIL PROTECTED]> writes:
> What can I do to help to debug it?
Either poke into the code yourself, or submit a self-contained test case
(the query alone does not a test case make). I can't offhand think of a
reason for 8.2.5 to be slower than 8.2.4 ...
re
The following bug has been logged online:
Bug reference: 3693
Logged by: Dirk Moebius
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Windows 2000
Description:PSQLException when using ResultSet.getLong(String) in
turkish locale
Details:
Hi Tom,
> Either poke into the code yourself, or submit a self-contained test
> case (the query alone does not a test case make). I can't offhand
> think of a reason for 8.2.5 to be slower than 8.2.4 ...
preparing the test case was easier than I expected. It's attached. Fast
planning on 8.2.4,
Jakub Ouhrabka <[EMAIL PROTECTED]> writes:
> preparing the test case was easier than I expected. It's attached. Fast
> planning on 8.2.4, very slow on 8.2.5.
Hmm. I think there are two different bugs involved here. One is fixed
by the attached patch, and it masks the performance problem on your
