Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION - Mailing list pgsql-performance

From Frank van Vugt
Subject Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION
Date
Msg-id 200212031623.51513.ftm.van.vugt@foxi.nl
Whole thread Raw
In response to Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
> Probably not, since the first thing it does is to flatten the
> sub-select, leaving it with a concatenation expression in the
> WHERE-clause.

Ah, I see.

So, I'll just split this thingy into two seperate queries, starting with
creating a temp table containing the straight subselect results.

> We really need to fix the planner to be able to do merge/hash on
> "arbitrary expression = arbitrary expression", not only "Var = Var".

I can get around it, so I'm not complaining ;-)


Tom, thanks a *lot* for the prompt responses !!



Best,





Frank.


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: v7.2.3 versus v7.3 -> huge performance penalty for JOIN with UNION
Next
From: "Ben Gunter"
Date:
Subject: v7.3 planner and user-defined functions