Thanks Vadim!
This patch does help.
The simple join still uses two sequential scans though.
Is your tip regarding single-key vs. multi-key-indices still valid?
I don't see any performance difference between these two.
BTW: Has the spinlock code, that was discussed some days ago, made it
into 6.3.1.?
Ciao
Ulrich
> Thanks for help!
>
> This is patch for src/backend/optimizer/path/prune.c.
> Access pathes of pruned joinrels were not merged and better
> pathes were lost, sometimes...
>
> Vadim
>
Ciao
Das Boersenspielteam.
---------------------------------------------------------------------------
http://www.boersenspiel.de
Das Boersenspiel im Internet
*Realitaetsnah* *Kostenlos* *Ueber 6000 Spieler*
---------------------------------------------------------------------------