Re: gistchoose vs. bloat

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: gistchoose vs. bloat
Date: 2012-12-14 16:36:50
Message-ID: 50CB55A2.7080001@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2012-12-14 18:12:09 Re: gistchoose vs. bloat
Previous Message Andrew Dunstan 2012-12-14 16:36:01 Re: Assert for frontend programs?