Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Hash partitioning, what function is used to compute the hash?
From: Dennis Ryan <dennisr1963@xxxxxxxxxxx>
Date: Mon, 11 May 2020 04:33:22 +0000
Accept-language: en-US

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Hash partitioning, what function is used to compute the hash?
  - From: Laurenz Albe
- Re: Hash partitioning, what function is used to compute the hash?
  - From: Michael Lewis

Prev by Date: Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
Next by Date: Re: Hash partitioning, what function is used to compute the hash?
Previous by thread: How to restore database to previous state
Next by thread: Re: Hash partitioning, what function is used to compute the hash?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux