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?
Re: Why the planner does not use index for a large amount of data? Re: Why the planner does not use index for a large amount of data? Re: Why the planner does not use index for a large amount of data? Re: Why the planner does not use index for a large amount of data? |
| Список | 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 по дате отправления: