Re: BUG #14161: reverse index scan cann't use double link?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #14161: reverse index scan cann't use double link?
Дата
Msg-id 28977.1464447791@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #14161: reverse index scan cann't use double link?  (digoal@126.com)
Ответы Re: BUG #14161: reverse index scan cann't use double link?  (德哥 <digoal@126.com>)
Список pgsql-bugs
digoal@126.com writes:
>    in btree, leaf page has prev and next page. but when i use order by desc,
> it's not use the prev page link? it scan from root per leaf page.

You've provided no evidence whatsoever to support that claim.

> 9 page hint = meta + root + branch + 6 leaf
> 19 page hint = meta + 6(root + branch + leaf)

I think more likely what's happening is that one end of the index is
packed full and the other end is about 50% full.

            regards, tom lane

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

Предыдущее
От: dmigowski@ikoffice.de
Дата:
Сообщение: BUG #14162: No statistics for functions used as aggregates
Следующее
От: 德哥
Дата:
Сообщение: Re: BUG #14161: reverse index scan cann't use double link?