MDS. Dynamic directories. Theory and practice?

Question

PostgreSQL

Good afternoon!
The business needed to create a Master Data Service help system (not the one from Microsoft).
The idea is this: There is an example
structure at the database level . Dictionary (dictionaries) ValueType (data types) Column (dictionary fields) (fk_to_dictionary, fk_to_valuetype) Value (values) (fk_to_column) This structure will allow you to create any number of directories (virtual tables) with any number of fields. From the input data, I can only replace the fact that Postgresql and .net core were chosen at the design stage. How to properly organize such structures for fast extraction and insertion of large amounts of data (1000-1000000 records)?
Will there be enough postgre capabilities for such a volume and load? Will we be able to correctly implement versioning / historical data on postgre?
The question is rather brief, because so far everything is only at the design stage. We are currently collecting information on possible approaches.