Re: INSERT ... ON CONFLICT DO UPDATE

John R Pierce <pierce@xxxxxxxxxxxx> · Tue, 21 Jul 2015 00:23:44 -0700



    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