Re: Define hash partition for certain column values

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Голубева Яна <ishsha(at)yandex(dot)ru>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Define hash partition for certain column values
Date: 2021-01-12 14:55:31
Message-ID: CAHOFxGp=6x6mw22re3Eo7P9g4SmTc9j7_3FwP6_BsO3fa39CvA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 12, 2021 at 1:21 AM Голубева Яна <ishsha(at)yandex(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joel Jacobson 2021-01-12 15:16:41 Re: CASE WHEN idiomatic for functions with side-effect?
Previous Message Deepti Sharma S 2021-01-12 14:49:42 RE: Compatible compiler with Postgresql C++