Re: bad join performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: bad join performance
Date
Msg-id 19949.1061267078@sss.pgh.pa.us
Whole thread Raw
In response to Re: bad join performance  (pginfo <pginfo@t1.unisoftbg.com>)
List pgsql-performance
pginfo <pginfo@t1.unisoftbg.com> writes:
> sorry for my bad.
> My production server is 7.3.7, but the development is 7.3.1 and I ran the
> tests on 7.3.1.

> It is courios that on 7.3.1 the query is not constantly bad.
> From time to time it is running well.

Yeah, the mergejoin estimation bug doesn't bite in every case (if it
did, we'd have found it before release ;-)).  Please update to 7.3.4.

            regards, tom lane

pgsql-performance by date:

Previous
From: pginfo
Date:
Subject: Re: bad join performance
Next
From: pginfo
Date:
Subject: Re: bad join performance