The Mendix applications are getting older and older which is good. But is also means that table sizes can become huge. It is time that Mendix starts to support table partiioning (https://www.postgresql.org/docs/10/ddl-partitioning.html ) so that the data can be split up. Now you have to create your own archive tables and must wrestle with the problem of searching over different tables.
Regards,
Ronald