Re: bigint out of range

Ron <ronljohnsonjr@xxxxxxxxx> · Sat, 18 May 2019 17:14:59 -0500



    On 5/18/19 3:49 PM, Peter J. Holzer wrote:

    
      On 2019-05-18 15:19:22 -0500, Ron wrote:

      
        On 5/18/19 2:27 PM, Peter J. Holzer wrote:

        
          On 2019-05-18 10:49:53 -0700, David G. Johnston wrote:

          
            You don’t perform math on a hash

          
          That's not generally true. Hashes are used for further computation for
example in hash tables or in cryptography.

        
        How is it "using math" to use a hash key in a hash lookup table?

      
      hash modulo table size.
    
    
    I've seen that used when the tablespace is pre-allocated,
    and you hash modulo the tablespace page number.  (Yes,
    performance tanks when you start filling up pages.)  How do you hash
    on the (ever growing) table size?

    
    -- 

      Angular momentum makes the world go 'round.