Postgres Pro
Downloads
Home   >   mailing lists

Re: Sequential scan being used despite indexes - Mailing list pgsql-performance

From Michael Fuhr
Subject Re: Sequential scan being used despite indexes
Date
Msg-id 20060201035803.GA6324@winnie.fuhr.org
Whole thread Raw
In response to Re: Sequential scan being used despite indexes  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Sequential scan being used despite indexes  (James Russell <internationalhobo@gmail.com>)
List pgsql-performance
Tree view 
On Tue, Jan 31, 2006 at 07:29:51PM -0800, Joshua D. Drake wrote:
> > Any ideas?
>
> What does explain analyze say?

Also, have the tables been vacuumed and analyzed?

--
Michael Fuhr

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Sequential scan being used despite indexes
Next
From: "Jeffrey W. Baker"
Date:
Subject: Re: Huge Data sets, simple queries