Re: [HACKERS] Reminder: Indices are not used - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] Reminder: Indices are not used
Date
Msg-id 351F0F30.82D2A631@sable.krasnoyarsk.su
Whole thread Raw
In response to Re: [HACKERS] Reminder: Indices are not used  (Bruce Momjian <maillist@candle.pha.pa.us>)
List 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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Reference Manual]
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [DOCS] Reference Manual