Most proper partitioning form on an integer column

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

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 pick up between
range, list and hash.

Thank you very much in avance for your help
Mimo

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2021-04-18 19:28:12 Re: Most proper partitioning form on an integer column
Previous Message Kenneth Marshall 2021-04-16 21:52:37 Re: OLEDB for PostgreSQL