Re: gistchoose vs. bloat

Heikki Linnakangas <hlinnakangas@vmware.com>

From: Heikki Linnakangas <hlinnakangas@vmware.com>
To: Alexander Korotkov <aekorotkov@gmail.com>
Cc: Jeff Davis <pgsql@j-davis.com>, Andres Freund <andres@2ndquadrant.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, pgsql-hackers@postgresql.org
Date: 2012-12-14T16:36:50Z
Lists: pgsql-hackers
One question: does the randomization ever help when building a new 
index? In the original test case, you repeatedly delete and insert 
tuples, and I can see how the index can get bloated in that case. But I 
don't see how bloat would occur when building the index from scratch.

BTW, I don't much like the option name "randomization". It's not clear 
what's been randomized. I'd prefer something like 
"distribute_on_equal_penalty", although that's really long. Better ideas?

- Heikki