Postgres Pro
Downloads
Home   >   mailing lists

why Sequencial Scan when selecting on primary key of table? - Mailing list pgsql-performance

From Brian Tarbox
Subject why Sequencial Scan when selecting on primary key of table?
Date
Msg-id 004301c32791$f983c710$01000001@trouble
Whole thread Raw
In response to Re: Enabling and Disabling Sequencial Scan  ("Nikolaus Dilger" <nikolaus@dilger.cc>)
Responses Re: why Sequencial Scan when selecting on primary key of table?
Re: why Sequencial Scan when selecting on primary key of table?
List pgsql-performance
Tree view 
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?

Brian Tarbox

pgsql-performance by date:

Previous
From: "Nikolaus Dilger"
Date:
Subject: Re: Enabling and Disabling Sequencial Scan
Next
From: Andrew Sullivan
Date:
Subject: Re: why Sequencial Scan when selecting on primary key of table?