On 7/20/2015 7:01 AM, Geoff Winkless wrote:
>
>
>
> Some web research suggests that random sequences are not great for
> indexes because of the resultant "keyspace fragmentation". I'm
> assuming that means a low number of nodes in the btree leafs, so an
> increase in memory usage for the index?
that suggests some folks overthink their indexing strategies and end up
'overoptimized'.
anyways, a simple REINDEX fixes all sorts of index fragmentation
--
john r pierce, recycling bits in santa cruz