Re: GiST buffering build, bug in levelStep calculation - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: GiST buffering build, bug in levelStep calculation
Date
Msg-id CAPpHfdvnUuuQoze9NZt6AnThaJiP2a770HO5EozaPH=n3ZGbzQ@mail.gmail.com
Whole thread Raw
In response to Re: GiST buffering build, bug in levelStep calculation  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Uh, I change my mind about commit_delay + commit_siblings (sort of)
Next
From: Atri Sharma
Date:
Subject: heap_form_tuple crashing