On Fri, Dec 2, 2016 at 1:54 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>> I want to split when the average bucket
>> contains 10 pages worth of tuples.
>
> oh, I think what you mean to say is hack the code to bump fill factor
> and then test it. I was confused that how can user can do that from
> SQL command.
Yes, that's why I said "hacking the fill factor up to 1000" when I
originally mentioned it.
Actually, for hash indexes, there's no reason why we couldn't allow
fillfactor settings greater than 100, and it might be useful.
Possibly it should be the default. Not 1000, certainly, but I'm not
sure that the current value of 75 is at all optimal. The optimal
value might be 100 or 125 or 150 or something like that.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company