To add to responses that you already got there's also a nice use case that partitioning helps with. When you have table that you constantly inserting large amo

To add to responses that you already got there's also a nice use case that partitioning helps with. When you have table that you constantly inserting large amount of data, and simliarly you are removing old data at the same frequency (i.e. only care about month of data). If you set partition for example per day, it's way faster to drop old tables than performing a delete.