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

From Tom Lane
Subject Re: index not being used. Why?
Date
Msg-id 321.1173457766@sss.pgh.pa.us
Whole thread Raw
In response to index not being used. Why?  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Responses Re: index not being used. Why?  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Running in single instance mode  ("Karthikeyan Sundaram" <skarthi98@hotmail.com>)
List pgsql-sql
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: Andrew Sullivan
Date:
Subject: Re: index not being used. Why?
Next
From: Steve Midgley
Date:
Subject: Re: A form of inheritance with PostgreSQL