Re: gistchoose vs. bloat - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: gistchoose vs. bloat
Date
Msg-id 50CB55A2.7080001@vmware.com
Whole thread Raw
In response to Re: gistchoose vs. bloat  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: gistchoose vs. bloat  (Jeff Davis <pgsql@j-davis.com>)
List 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



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Assert for frontend programs?
Next
From: Jeff Davis
Date:
Subject: Re: gistchoose vs. bloat