Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group