Most proper partitioning form on an integer column

2021-04-18 Thread Il Mimo di Creta
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 y

Re: Most proper partitioning form on an integer column

2021-04-18 Thread Justin Pryzby
On Sun, Apr 18, 2021 at 08:07:35PM +0200, Il Mimo di Creta wrote: > 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 part