Re: Need guidance on partioning

> On May 22, 2024, at 2:40 PM, M Sarwar <sarwarmd02(at)outlook(dot)com> wrote:
>
> No-one has started complaining about anything so far. I will not be surprising if someone start crying all of sudden.
> My management has highly underestimates the database tasks. I am just listening to them with their priority order. Otherwise, my job will be at risk 🙂

Hi Sarwar,

What you’ll find is that for OLTP systems table sizes doesn’t really matter as access patterns should be well structured and serviced by indexes, etc. The only reason to have partitioning in an OLTP system is for table maintenance; like aging out old data for regulatory reasons, etc.

Partitioning is most beneficial in OLAP and reporting type systems where queries can make use of partition elimination. When thinking about partitioning I also consider the use of Brin indexes as they can sometime achieve similar or even better results. Also, when considering partitioning especially in a hybrid system one should also think about how it will impact referential integrity.