Re: Index only scan sometimes switches to sequential scan for small amount of rows

Поиск
Список
Период
Сортировка
От Feike Steenbergen
Тема Re: Index only scan sometimes switches to sequential scan for small amount of rows
Дата
Msg-id CAK_s-G1fH2Rv8K7i6vKRj1=xr6s3E1bJvFT7RcgEMz5BBAtgDw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index only scan sometimes switches to sequential scan for small amount of rows  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On 25 March 2015 at 22:45, Jeff Janes <jeff.janes@gmail.com> wrote:

> How can the avg_width be 4 when the vast majority of entries are 7
> characters long?

The datatype is an enum, as I understand it, an enum type always
occupies 4 bytes

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Index only scan sometimes switches to sequential scan for small amount of rows
Следующее
От: Feike Steenbergen
Дата:
Сообщение: Re: Index only scan sometimes switches to sequential scan for small amount of rows