Why the planner does not use index for a large amount of data? - Mailing list pgsql-general

Hi,
When I used explain I found that the query planner use a seq scan to execute a query on a table containing about 2 millions rows.However I'm creating an index.Why does the planner uses seq scan in place of index scan?Does the execution of index scan is slower with table containing a huge amount of data?

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: a back up question
Next
From: Melvin Davidson
Date:
Subject: Re: Why the planner does not use index for a large amount of data?