Horton
Menu

Re: Sequential scan being used despite indexes

Michael Fuhr <mike@fuhr.org>

View thread
From: Michael Fuhr <mike@fuhr.org>
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: James Russell <internationalhobo@gmail.com>, pgsql-performance@postgresql.org
Date: 2006-02-01T03:58:04Z
Lists: pgsql-performance 
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