Why the planner does not use index for a large amount of data?

Поиск
Список
Период
Сортировка
От hmidi slim
Тема Why the planner does not use index for a large amount of data?
Дата
Msg-id CAMsqVxtGL4cO7iWTcfypxpeEAKQ3gzvqutCstqhJZJts4pKUmA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Why the planner does not use index for a large amount of data?  (Melvin Davidson <melvin6925@gmail.com>)
Re: Why the planner does not use index for a large amount of data?  (Melvin Davidson <melvin6925@gmail.com>)
Re: Why the planner does not use index for a large amount of data?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Why the planner does not use index for a large amount of data?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Why the planner does not use index for a large amount of data?  (Jim Finnerty <jfinnert@amazon.com>)
Список 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 по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: a back up question
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Why the planner does not use index for a large amount of data?