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

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Hash partitioning, what function is used to compute the hash?
Дата
Msg-id CAHOFxGrT6jUAdoz3bKMzkM66jP6JsF5=4vAKJ3GMwkjBkuxKWA@mail.gmail.com
обсуждение исходный текст
Ответ на Hash partitioning, what function is used to compute the hash?  (Dennis Ryan <dennisr1963@outlook.com>)
Ответы Re: Hash partitioning, what function is used to compute the hash?
Список pgsql-general
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 по дате отправления: