From: | Tim McAuley <mcauleyt(at)tcd(dot)ie> |
---|---|
To: | Mike Mascari <mascarm(at)mascari(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unused Indexes |
Date: | 2003-07-30 14:06:05 |
Message-ID: | 3F27D0CD.7000002@tcd.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Mike Mascari wrote:
>Tim McAuley wrote:
>
>
>>Hi,
>>
>>I have a table which I have populated with over 5000 entries. There is a
>>combined index placed on two of the columns (both bigint). I am trying
>>a simple select (i.e. select id where col1 = 1 and col2 = 1) covering
>>these two columns and it keeps using a seq scan. Is this correct? I
>>would have thought that with this number of entries that an index scan
>>should be used.
>>
>>
>
>You must cast the 1 to a bigint:
>
>SELECT id WHERE col1 = 1::bigint AND col1 = 2::bigint
>
>This should probably be listed under FAQ 4.8, but it isn't.
>
>
That's it!
I had actually just come across that before reading this email. It gets
the explain back into shape anyway!
Thanks!
Tim
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-07-30 14:25:21 | Re: Postgres Hanging on Inserts |
Previous Message | EDMUND DENGLER | 2003-07-30 13:49:54 | Re: Unused Indexes |