Scott Marlowe wrote:
> On Sun, Oct 16, 2011 at 2:41 PM, Szymon Guz <mabewlun(at)gmail(dot)com> wrote:
>
>> Hi,
>> just a couple of questions:
>> will there be an index bloat if I have:
>> - a serial column and only add rows to the table?
>> - a text column and I only add rows to the table?
>> For the serial column the numbers are only incremented, for the text column
>> I add random strings.
>>
>
> With no deletes or updates, the only bloat will be from a non 100% fill factor.
>
>
Is there no index rebalancing overhead on monotonically increasing keys
compare to (decently) random. Seems one would continuously write to the
"right-most" sub-leaf node.