Re: GiST buffering build, bug in levelStep calculation

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: GiST buffering build, bug in levelStep calculation
Дата
Msg-id CAPpHfdvnUuuQoze9NZt6AnThaJiP2a770HO5EozaPH=n3ZGbzQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: GiST buffering build, bug in levelStep calculation  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Thu, May 31, 2012 at 1:36 PM, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
I note that the calculations assume that leaf tuples and internal tuples have similar sizes. We calculate the average leaf tuple size, and use that to calculate the fan-out of internal pages. On some GiST opclasses, the values stored on internal pages might be quite different from the leaf tuples. I don't think we need to worry about that in practice, these calculations are not very accurate anyway, but perhaps a comment would be in order.

Probably we could collect per-level statistics of average tuple size?

------
With best regards,
Alexander Korotkov.

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Uh, I change my mind about commit_delay + commit_siblings (sort of)
Следующее
От: Atri Sharma
Дата:
Сообщение: heap_form_tuple crashing