Re: [GENERAL] Seq scan X Index scan

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] Seq scan X Index scan
Дата
Msg-id CAKFQuwY0hvhm8hkh==dRFqhTzY8CfQL3WvaWdaO4zBHnv15Jag@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Seq scan X Index scan  (Patrick B <patrickbakerbr@gmail.com>)
Список pgsql-general
On Wed, Mar 8, 2017 at 3:32 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
Why is SEQ SCAN faster than index scan?
 
Same number of evaluated record and less effort-per-record​.  You only win with an index if you can evaluate fewer records to make up for the extra effort per record that querying an index involves compared to just reading the actual data.

This is an environment t

​​
est but i'm running the same test on a production environment and also seq scan is cheaper than index.


Define (or show) production...

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Patrick B
Дата:
Сообщение: [GENERAL] Seq scan X Index scan
Следующее
От: John Iliffe
Дата:
Сообщение: Re: [GENERAL] Unable to start postgresql