Re: Optimizer(?) off by factor of 3 ... ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Optimizer(?) off by factor of 3 ... ?
Date: 2002-02-11 16:26:08
Message-ID: 7196.1013444768@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Marc G. Fournier" <scrappy(at)hub(dot)org> writes:
> -> Index Scan using clubs_idx on clubs c (cost=0.00..1695474.62 rows=26569 width=64) (actual time=0.48..1936.95 rows=23510 loops=1)

This indexscan cost estimate is completely out of whack, it would seem.

Have you done an ANALYZE on this table recently? If so, what do you get
from
select * from pg_stats where tablename = 'clubs';
select * from pg_class where relname = 'clubs';

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2002-02-11 16:39:21 Re: IFNULL -> COALESCE
Previous Message Tom Lane 2002-02-11 16:11:09 Re: Idea for making COPY data Microsoft-proof