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;
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 |