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