Re: PostGres is not using indices in select, I would like

On Mon, 24 Sep 2001, Dominique Dumortier wrote:

> The table is created this way:
>
> CREATE TABLE "city" (
> "ciname" character varying(80),
> "cix" smallint,
> "ciy" smallint,
> "cilat" smallint,
> "cilong" smallint,
> "cialt" smallint,
> "cicocode" smallint,
> "cimacode" character(1),
> "cictcode" character(1)
> );
>
> COPY "city" FROM stdin;
> Abat 1030 504 4233 1981 1130 8 H T
> Abate 1030 504 4233 1981 1130 8 H T
> Abati 1030 504 4233 1981 1130 8 H T
> The table contains about 750000 lines such as the ones above.
>
>
> The index is created like that:
>
> CREATE INDEX ci_index on city (cix,ciy)
>
> If I do select ciname from city where cix=400 and ciy=500;

Ah, you're probably running into the integer constants being int4
problem. I'd suggest making the smallints into regular ints, or
explicitly casting the constants to smallint.