Most proper partitioning form on an integer column

From: Il Mimo di Creta <mimo(dot)creta(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Most proper partitioning form on an integer column
Date: 2021-04-19 07:03:07
Message-ID: CAPDeFrfoZwc3CCSJvDQRGxw+A1Hk0edR9YmMyOt0jENiQhPcew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I need to partition a table on an integer column, which represents the
month of an event, so 12 distinct values.
I am just wondering if any of you has experience about which is the best
way to go with such a use case, in particular which method to pick up
between range, list and hash.

Thank you very much in advance for your help
Mimo

Browse pgsql-admin by date

  From Date Subject
Next Message aditya desai 2021-04-19 13:10:29 Re: OLEDB for PostgreSQL
Previous Message Laurenz Albe 2021-04-18 20:16:34 Re: Reordering the fields in a table