From: | "Richard Huxton" <dev(at)archonet(dot)com> |
---|---|
To: | "hubert depesz lubaczewski" <depesz(at)depesz(dot)pl>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: int8 indices? |
Date: | 2001-08-07 09:09:58 |
Message-ID: | 008201c11f20$f1fa1ec0$1001a8c0@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
From: "hubert depesz lubaczewski" <depesz(at)depesz(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Joerdens | 2001-08-07 10:18:03 | Re: minimum hardware for Postgresql Install |
Previous Message | Dr. Evil | 2001-08-07 09:01:06 | Still wondering about random numbers... |