Re: bigint out of range

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: bigint out of range
Date: 2019-05-18 22:14:59
Message-ID: 55d8ce6e-2a94-1003-0fc1-66a39d6d2e8a@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Aquino 2019-05-18 22:33:01 Re: PostgreSQL on Amazon RDS
Previous Message Peter J. Holzer 2019-05-18 20:49:41 Re: bigint out of range