Re: [HACKERS] indexes and floats

On 03-Aug-98 Thomas G. Lockhart wrote:
>> Is this a bug that the index doesn't work on floats or is it a
>> datatype mismatch thing?
>> Seq Scan on foo  (cost=0.00 size=0 width=8)
>
> Likely neither. Notice the cost of a sequential scan; it is zero. Why
> bother doing an index scan?
>
> You need at least two more things to happen to provoke Postgres into
> using your index:
>
> 1) Have more entries in the table; rule of thumb is O(100) before an
> index will be used.
>
> 2) Run vacuum after getting that many entries to make sure the optimizer
> will know about the configuration of the tables and indices.

Here's why I'm bringing it up.  I ran vacuum on the database yesterday.
The table consists of city, state (both text), lon and lat (both float4).
The text index is working but not the floats.  I have another table with
12,000 - 14,000 rows and I'm getting the same thing.

-----

campsites=> explain select lon from locations where lon = 83.5;
NOTICE:  QUERY PLAN:

Seq Scan on locations  (cost=7263.30 size=2 width=4)

EXPLAIN
campsites=> select count(*) from locations;
 count
------
169797
(1 row)

campsites=>

-----


Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null
       # include <std/disclaimers.h>                   TEAM-OS2
   Online Searchable Campground Listings    http://www.camping-usa.com
       "There is no outfit less entitled to lecture me about bloat
               than the federal government"  -- Tony Snow
==========================================================================