Re: index not being used. Why? - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: index not being used. Why?
Date
Msg-id 20070309160211.GA24502@phlogiston.dyndns.org
Whole thread Raw
In response to index not being used. Why?  (Gerardo Herzig <gherzig@fmed.uba.ar>)
List pgsql-sql
On Fri, Mar 09, 2007 at 12:01:30PM -0300, Gerardo Herzig wrote:
> Hi all. I have this 2 relations

How big are they?

>   ->  Hash  (cost=9.08..9.08 rows=408 width=55)
>         ->  Seq Scan on pages  (cost=0.00..9.08 rows=408 width=55)

The planner thinks it will get 408 rows.  How big a percentage of the
table is that?  

Also, what does EXPLAIN ANALYSE say about this?

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
If they don't do anything, we don't need their acronym.    --Josh Hamilton, on the US FEMA


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: index not being used. Why?
Next
From: Tom Lane
Date:
Subject: Re: index not being used. Why?