Postgres Pro
Downloads
Home   >   mailing lists

Most proper partitioning form on an integer column - Mailing list pgsql-admin

From Il Mimo di Creta
Subject Most proper partitioning form on an integer column
Date
Msg-id CAPDeFrfoZwc3CCSJvDQRGxw+A1Hk0edR9YmMyOt0jENiQhPcew@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Reordering the fields in a table
Next
From: Yambu
Date:
Subject: replication checkpoint has wrong magic