3 ms·
To my mind, the right maximum size of a partition is such that your important queries are still fast. This often means that your most important indexes for the
by nine_k 4y ago
To my mind, the right maximum size of a partition is such that your important queries are still fast. This often means that your most important indexes for the partition that serves most queries fit in RAM. So it's highly specific to a particular schema.
Often partitions are made for time-related data, and these partitions may have smaller granularity. Say, you want to keep last 6 months of data, but make the partitions week-sized, or even day-sized, to make transitions more smooth.