Re: bigint out of range - Mailing list pgsql-general

From Ron
Subject Re: bigint out of range
Date
Msg-id 55d8ce6e-2a94-1003-0fc1-66a39d6d2e8a@gmail.com
Whole thread Raw
In response to Re: bigint out of range  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Responses Re: bigint out of range
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: bigint out of range
Next
From: Alex Aquino
Date:
Subject: Re: PostgreSQL on Amazon RDS