Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Lewis
Subject Re: Hash partitioning, what function is used to compute the hash?
Date
Msg-id CAHOFxGrT6jUAdoz3bKMzkM66jP6JsF5=4vAKJ3GMwkjBkuxKWA@mail.gmail.com
Whole thread Raw
In response to Hash partitioning, what function is used to compute the hash?  (Dennis Ryan <dennisr1963@outlook.com>)
Responses Re: Hash partitioning, what function is used to compute the hash?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
Tree view
The documentation shows it is just a modulus operation. If you partition on object_key % 3 then you will create three partitions for remainder values 0-2 for instance.

Afaik, hash partition doesn't have real world expected use cases just yet. List or range is probably what you want to use.

pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPAREsid_sisisinst FROM :select_anw;'
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'