I am building an ASP.NET MVC 5 project with PostgreSQL database, in this database there is a history table that will grow by about 500,000 lines per month and we will have reports that will take data from periods of one year. So we thought about using MongoDb for this particular table and the rest of the database would be with PostgreSQL. Since we will perform much better on this table using MongoDb.
Is it worth using this kind of architecture with PostgreSQL and MongoDb in the same project? If so, what is the best way to do it and what tools? If not, what is the most appropriate method?