Re: PostgreSQL does not choose my indexes well

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL does not choose my indexes well
Дата
Msg-id 14950.1587659476@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL does not choose my indexes well  (Michael Lewis <mlewis@entrata.com>)
Список pgsql-performance
Michael Lewis <mlewis@entrata.com> writes:
>> "unless the table is mostly marked all-visible"

> Is that taken into account during planning when evaluating index scan vs
> sequential scan?

It is, although the planner's estimate is based on what the last ANALYZE
saw, which might be out-of-date.

            regards, tom lane



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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: PostgreSQL does not choose my indexes well
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: PostgreSQL does not choose my indexes well