Re: [HACKERS] Reminder: Indices are not used

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*
---------------------------------------------------------------------------