Re: [HACKERS] Reminder: Indices are not used

From: "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: Ulrich Voss <voss(at)vocalweb(dot)de>, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Reminder: Indices are not used
Date: 1998-03-30 03:19:13
Message-ID: 351F0F30.82D2A631@sable.krasnoyarsk.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian wrote:
>
> > test=> explain SELECT * from Trans, Kurse where
> > Kurse.wpk_nr=Trans.wpk_nr and Trans.spieler_nr=3;
> > NOTICE: QUERY PLAN:
> >
> > Hash Join (cost=408.60 size=1364 width=103)
> > -> Seq Scan on kurse (cost=238.61 size=4958 width=65)
> > -> Hash (cost=0.00 size=0 width=0)
> > -> Index Scan on trans (cost=3.41 size=29 width=38)
> >
> > I get the seq scan, which slows the query down tremendously compared to
> > 6.2.
>
> This does help. Vadim, can you check this?

Ok.

Vadim

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-03-30 05:16:16 Re: Let's talk up 6.3
Previous Message Vadim B. Mikheev 1998-03-30 02:38:08 Re: [HACKERS] Optimizer fails?