Postgres Pro
Downloads
Home   >   mailing lists

Hash partitioning, what function is used to compute the hash? - Mailing list pgsql-general

From Dennis Ryan
Subject Hash partitioning, what function is used to compute the hash?
Date
Msg-id DM6PR06MB45883312576C92AEB23045BEB8A10@DM6PR06MB4588.namprd06.prod.outlook.com
Whole thread Raw
Responses Re: Hash partitioning, what function is used to compute the hash?  (Michael Lewis <mlewis@entrata.com>)
Re: Hash partitioning, what function is used to compute the hash?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view

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 for Windows 10

 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to restore database to previous state
Next
From: Niels Jespersen
Date:
Subject: SV: what to log in csvlogs