Re: Sequential scan being used despite indexes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx>
Subject: Re: Sequential scan being used despite indexes
From: Michael Fuhr <mike@xxxxxxxx>
Date: Tue, 31 Jan 2006 20:58:04 -0700
Cc: James Russell <internationalhobo@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <43E02B2F.9070202@xxxxxxxxxxxxxxxxx>
References: <3a3a16930601311914w5bd7d1d0hde7b4e495e0deb27@xxxxxxxxxxxxxx> <43E02B2F.9070202@xxxxxxxxxxxxxxxxx>

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

Follow-Ups:
- Re: Sequential scan being used despite indexes
  - From: James Russell

References:
- Sequential scan being used despite indexes
  - From: James Russell
- Re: Sequential scan being used despite indexes
  - From: Joshua D. Drake

Prev by Date: Re: Sequential scan being used despite indexes
Next by Date: Re: Huge Data sets, simple queries
Previous by thread: Re: Sequential scan being used despite indexes
Next by thread: Re: Sequential scan being used despite indexes
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux