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

From Gerardo Herzig
Subject Re: index not being used. Why?
Date
Msg-id 45F18DC7.9050805@fmed.uba.ar
Whole thread Raw
In response to Re: index not being used. Why?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Someday i will ask some question that will makes you think a little 
more. You'll see.
I will populate the tables and redo the explain.

Thanks dudes!!
Gerardo

>Gerardo Herzig <gherzig@fmed.uba.ar> writes:
>  
>
>>Watch the last row of the explain command. It makes a sequential scan on the pages table, like it is not using the
indexon the "id" field.
 
>>The result itself is OK, but i will populate the tables so i think that later that sequential scan would be a
problem.
>>    
>>
>
>Why do you think that the plans won't change when the tables get bigger?
>
>            regards, tom lane
>
>
>  
>



pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: A form of inheritance with PostgreSQL
Next
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Statistics