Hash partitioning, what function is used to compute the hash?

From: Dennis Ryan <dennisr1963(at)outlook(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Hash partitioning, what function is used to compute the hash?
Date: 2020-05-11 04:33:22
Message-ID: DM6PR06MB45883312576C92AEB23045BEB8A10@DM6PR06MB4588.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Regarding hash partitioning, what is the function/algorithm that is used to compute the hash for the partition key? I need to write a query like

“SELECT unknown_partition_hash_function(id) AS hash_value, COUNT(id) AS number_of_records
FROM existing_table
GROUP BY 1”

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Niels Jespersen 2020-05-11 05:15:52 SV: what to log in csvlogs
Previous Message David G. Johnston 2020-05-11 00:25:41 Re: How to restore database to previous state