At 09:58 PM 11/28/02 -0500, you wrote:
>Hm. Are we sure that both versions were built with the same
>optimization level, etc? (My private bet is that Wade's 7.2 didn't
>have multibyte or locale support --- but that's a long shot when we
>don't know the datatypes of the columns being joined on...)
Neil Conway <[EMAIL PROTECTED]> writes:
> I was looking at this a bit in IRC, and I was more concerned by the fact
> that 7.3 was 20% than 7.2 on the same hardware, when they both used the
> same query plan (consider the data at the end of the URL above, after
> the execution of 'SET enable_mergejo
On Thu, 2002-11-28 at 21:23, Tom Lane wrote:
> wade <[EMAIL PROTECTED]> writes:
> > Explain output can be found at http://arch.wavefire.com/72v73a.txt
>
> The difference evidently is that 7.3 chooses a mergejoin where 7.2
> picks a hashjoin.
I was looking at this a bit in IRC, and I was more conc
wade <[EMAIL PROTECTED]> writes:
> While playing with one of my DBs under 7.3 to make use of its better
> explain features, I came across a query that runs significantly slower
> under 7.3 than
> 7.2.3. At first, I thought it would be a hardware issue, so i installed both
> versions on the same
While playing with one of my DBs under 7.3 to make use of its better
explain features, I came across a query that runs significantly slower
under 7.3 than
7.2.3. At first, I thought it would be a hardware issue, so i installed both
versions on the same box.
7.2.3 tends to run the query in 80%
