Thread

Re: [HACKERS] Reminder: Indices are not used

Boersenspielteam <boersenspiel@vocalweb.de> — 1998-04-03T19:01:23Z

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