Re: Define hash partition for certain column values - Mailing list pgsql-general

From Michael Lewis
Subject Re: Define hash partition for certain column values
Date
Msg-id CAHOFxGp=6x6mw22re3Eo7P9g4SmTc9j7_3FwP6_BsO3fa39CvA@mail.gmail.com
Whole thread Raw
In response to Re: Define hash partition for certain column values  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, Jan 12, 2021 at 1:21 AM Голубева Яна <ishsha@yandex.ru> wrote:
List or range partitioning isn't suitable for my case.
I am using a column of numeric(20) type as a base for partitioning. The values of the column are generated randomly. 
So there will be too many partitions if I use list partitioning as is.

Sorry, but why is range not suited for this? It would seem fairly trivial to create 50 or 1000 partitions to break up the range of values allowed by your field definition.

pgsql-general by date:

Previous
From: Deepti Sharma S
Date:
Subject: RE: Compatible compiler with Postgresql C++
Next
From: "Joel Jacobson"
Date:
Subject: Re: CASE WHEN idiomatic for functions with side-effect?