gist cost estimator failing

From: strk <strk(at)keybit(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: gist cost estimator failing
Date: 2004-09-14 08:59:06
Message-ID: 20040914085906.GB504@freek.keybit.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This might be gist-related or not. The cost estimator
is wrongly estimating an higher cost on Index Scan then
it estimates on Seq Scan (while reality shows the difference).

I've found out that the gistcostestimate function is just
a stub calling the genericcostestimate, can this be the problem ?

Can you point me to where to inspect further ?

Seq Scan on plmshp02_1
(cost=0.00..19.14 rows=26 width=81)
(actual time=0.54..61.68 rows=75 loops=1)
Total runtime: 61.83 msec

Index Scan using plmshp02_1_gist on plmshp02_1
(cost=0.00..81.53 rows=26 width=81)
(actual time=0.39..19.22 rows=75 loop=1)
Total runtime: 19.37 msecs

--strk;

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2004-09-14 08:59:57 Re: Why are there client-only encodings?
Previous Message strk 2004-09-14 08:55:30 pg_restore segfault with pg-CVS