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 run
about 3X slower. What do I have to do to get postgres to use indexes?
In response to
pgsql-performance by date
|Next:||From: Andrew Sullivan||Date: 2003-05-31 17:02:08|
|Subject: Re: why Sequencial Scan when selecting on primary key of table?|
|Previous:||From: Tom Lane||Date: 2003-05-31 16:13:12|
|Subject: Re: db growing out of proportion |