Sequential Scan Index Bug

From: "Gabriel Weinberg" <yegg(at)alum(dot)mit(dot)edu>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Sequential Scan Index Bug
Date: 2004-04-03 18:51:56
Message-ID: 000001c419ac$bf20be80$0900a8c0@yegg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


I have a table with an integer column with about 10M rows in it.

This column has an index (btree).

When I try to select a row using this column with an integer, e.g. select *
from table where id=4, it always uses the index. However, if I select try
to select a row using this column with a decimal, e.g. select * from table
where id=4.343, it skips the index entirely and does a sequential scan of
the table.

I am using v7.4.2 on Freebsd 4.9.

Gabriel

_________________
Gabriel Weinberg
yegg(at)alum(dot)mit(dot)edu

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-04-04 13:09:02 BUG #1125: Running PostgreSQL 7.4.2 on Windows 2000 with Cygwin
Previous Message PostgreSQL Bugs List 2004-04-03 18:27:54 BUG #1124: Re: Bug #1122