Define hash partition for certain column values

From: Голубева Яна <ishsha(at)yandex(dot)ru>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Define hash partition for certain column values
Date: 2021-01-11 05:56:52
Message-ID: 2278581610342154@mail.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<div>Hello,</div><div> </div><div>I've found in source code that there is a function satisfies_hash_partition(oid, modulus, remainder, column_values[]) which allows to check if the certain column value will be placed in the certain partition.</div><div>I' d like to know if there is an opportunity not to check the certain partition but to define which partition will be the certain column value placed in. Something like define_hash_partition(oid, column_values[]) which returns the remainder value.</div><div>It is not very convenient to use satisfies_hash_partition for this purpose because there could be a lot of partitions and it takes time to check each one of them.</div><div>If there isn't such opportunity for now I think it would be useful to have such feature in the next releases. What do you think about it?</div><div> </div><div>Thank you!</div><div>Iana Golubeva</div>

Attachment Content-Type Size
unknown_filename text/html 890 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-01-11 06:36:08 Re: Define hash partition for certain column values
Previous Message raf 2021-01-10 12:57:50 Re: How to keep format of views source code as entered?