Re: BIGINT indexes still with problems

On Mon, 9 Aug 2004, Dan Ruthers wrote:

> Now, if I run this query (note the int8 cast - also tried with the '' cast to String, same results):
> test=> explain select * from dmaildatum where idparent=int8(783219);
> QUERY PLAN
> ------------------------------------------------------------------
> Seq Scan on dmaildatum (cost=0.00..2241.71 rows=2229 width=272)
> Filter: (idparent = 783219::bigint)
> (2 rows)
>
> The index is not used. But with an identical query, only different parameter value:
> desknow=> explain select * from dmaildatum where idparent=int8(1187838);
> QUERY PLAN
>
> --------------------------------------------------------------------------------
> ---------------
> Index Scan using ix_dmaildatum_idparent on dmaildatum (cost=0.00..284.05 rows=
> 102 width=272)
> Index Cond: (idparent = 1187838::bigint)
> (2 rows)

Look at the row estimates for the two cases. How many rows are actually
returned and how long the queries take (explain analyze will give that
information)?