Index not used when using a function - Mailing list pgsql-general

From Nick
Subject Index not used when using a function
Date
Msg-id 45d619f5-7dec-416d-90d8-04849b10367f@a6g2000yqm.googlegroups.com
Whole thread Raw
Responses Re: Index not used when using a function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
SELECT * FROM locations WHERE id = 12345 LIMIT 1

uses the primary key (id) index, but...

SELECT * FROM locations WHERE id = get_location_id_from_ip(641923892)
LIMIT 1

does not and is verrry slow. Any ideas why? Whats weird is that it
works (uses index) on a previous db, but when I copied everything over
to a new db it doesnt. Ive ran vacuum + analyze, does the planner just
need more time to figure out that it needs to use an index?

pgsql-general by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: postgres
Next
From: akuster
Date:
Subject: Re: How to subscribe to your security list?