![From Gas Station to Google with Self-Taught Cloud Engineer Rishab Kumar [Podcast #158]](https://cdn.hashnode.com/res/hashnode/image/upload/v1738339892695/6b303b0a-c99c-4074-b4bd-104f98252c0c.png?#)
What is the good example of table patitioning?
I've read several artivles about table partitioning(don't confuse with sharding) but all of them are quite abstract. They just say that sometimes it is good to divide table on parts(by rows). But I want to see a good example when it could solve a real problem ? I thought about user analytics... lets imagine that user analytics is more popular for the day so we can partition this table by days... but at this case we will have today partition red but other partition will be almost unused. So I've got it is a bad example for partition.
I've read several artivles about table partitioning(don't confuse with sharding) but all of them are quite abstract. They just say that sometimes it is good to divide table on parts(by rows).
But I want to see a good example when it could solve a real problem ?
I thought about user analytics... lets imagine that user analytics is more popular for the day so we can partition this table by days... but at this case we will have today partition red but other partition will be almost unused. So I've got it is a bad example for partition.
