| From: | "Boersenspielteam" <boersenspiel(at)vocalweb(dot)de> |
|---|---|
| To: | "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su> |
| Cc: | PostgreSQL Hackers <hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] Reminder: Indices are not used |
| Date: | 1998-04-03 19:01:23 |
| Message-ID: | 199804031705.TAA06588@binky.de.uu.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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*
---------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edmund Mergl | 1998-04-03 19:38:36 | [Fwd: pgsql_perl5 problem to compile on IRIX 6.4] |
| Previous Message | Thomas G. Lockhart | 1998-04-03 16:07:20 | Re: [PATCHES] Re: pg_dump -z [Please don't apply this] |