Hello, I am working on a search engine that indexes classified ads from Craigslist and Backpage. The system indexes about 3,000,000 ads a day and each ad stays in the system for 30 days. Once I hit 30 days from release I should always have around 90,000,000 ads in the system. Working with this many ads is very demanding, I think I need to set up partitioning. Each ad is inserted into the ads table with a state id, city id, category id and subcategory id. I really wanted to partition my ads table by State but I have no idea how to. I've read some tutorials and can't get anywhere.