Re: int8 indices?

From: "hubert depesz lubaczewski" <depesz@depesz.pl>

> depesz=# select version();
>                             version
> ---------------------------------------------------------------
>  PostgreSQL 7.2devel on i686-pc-linux-gnu, compiled by GCC 3.0
> (1 row)
>
> (compiled from cvs 2 days ago).

PG 7.2dev, GCC 3.0 - you're just showing off ;-)

> of course i vacuum'ed, but when i select anything from the table i get
> seqscan:
> depesz=# explain select * from a where id = 6970;
> NOTICE:  QUERY PLAN:
>
> Seq Scan on a  (cost=0.00..465.76 rows=1 width=8)

Try where id=6970::int8 - I seem to remember Tom Lane saying the planner got
upset because the constant got cast to an int4 and of course you don't have
an int4 index...

HTH

- Richard Huxton