On Fri, Dec 2, 2016 at 1:54 AM, Amit Kapila <amit.kapil...@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 -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers