I have a simple table with a dozen integer fields and a primary key.
When I say "explain select * from Patient where Patient_primary_key = 100"
I get sequential scan.
I've just converted my application from MySQL and am seeing everything runabout 3X slower. What do I have to do to get postgres to use indexes?