Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group