Skip site navigation (1) Skip section navigation (2)

Re: Sequential scan being used despite indexes

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: James Russell <internationalhobo(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Sequential scan being used despite indexes
Date: 2006-02-01 03:58:04
Message-ID: 20060201035803.GA6324@winnie.fuhr.org (view raw or flat)
Thread:
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

In response to

Responses

pgsql-performance by date

Next:From: Jeffrey W. BakerDate: 2006-02-01 04:09:40
Subject: Re: Huge Data sets, simple queries
Previous:From: Joshua D. DrakeDate: 2006-02-01 03:29:51
Subject: Re: Sequential scan being used despite indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group