Postgres Pro
Downloads
Home   >   mailing lists

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

From Il Mimo di Creta
Subject Most proper partitioning form on an integer column
Date
Msg-id CAPDeFrcymc1NtgTdbsz1W65PMJQ7B7seGdOJpRZpDxL-mLTjng@mail.gmail.com
Whole thread Raw
Responses Re: Most proper partitioning form on an integer column
List pgsql-performance
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 pick up between range, list and hash.

Thank you very much in avance for your help
Mimo

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Disabling options lowers the estimated cost of a query
Next
From: Justin Pryzby
Date:
Subject: Re: Most proper partitioning form on an integer column