Consider global migration from Postgres

[telezhnaya]

We've already discussed this topic several times, it's better to collect all thoughts/requirements/ideas in one place so that we can make the decision faster when we decide to move on with the migration.

1. Why do we think about the migration? 1. The speed of SELECT queries degraded dramatically, and we have the feeling that it couldn't be improved in the current setup 2. I'm afraid that in one day we will have issues with the speed of INSERTs (it's not the bottleneck still; if we will meet this problem, the hotfix is to add the partitions)

2. The results of the discussions

• We anyway need to use relational DB: it suits the nature of the data perfectly
• Partitioning does not solve the main problem, we still have the same CPU limit
• We are thinking about the sharded solution (read: partitioning on several machines), the main candidate for now is https://www.singlestore.com
• It would be great to have the ability to share the dump of the DB to help the users run their own Indexer without the requirement to wait several weeks for collecting all historical data (see https://github.com/near/near-indexer-for-explorer/discussions/187)
• It's not the burning issue; it's still possible to solve all our problems with the current solution + https://github.com/near/near-analytics