I want to parition my huge table to solve a performance issue, but the attibute on which I want to parition my table resides in another table that is related by FK.
Here are my tables:
Article (Table1) id submit_date ... Concept (Table2) id article_id (FK) ...
So, I want to parition Concept table based on submit_date attribute from the article table (like split it by months). Is it possible with PostgreSQL?