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

Re: [HACKERS] Reminder: Indices are not used

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: voss(at)vocalweb(dot)de (Ulrich Voss)
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Reminder: Indices are not used
Date: 1998-03-27 19:26:59
Message-ID: 199803271926.OAA18458@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> 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?

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-03-27 19:37:46
Subject: Re: [HACKERS] Going on vacation
Previous:From: Michael MeskesDate: 1998-03-27 16:53:01
Subject: Going on vacation

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