Re: bad join performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: bad join performance
Date: 2003-08-19 04:24:38
Message-ID: 19949.1061267078@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

pginfo <pginfo(at)t1(dot)unisoftbg(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shridhar Daithankar 2003-08-19 06:28:45 Re: Insert performance
Previous Message pginfo 2003-08-19 03:25:42 Re: bad join performance