Here is one PostgreSQL database which has 100 tables and each table has 10,000 records and also each record has 512 characters in JSON format. On the other side is one server(Java) that socket With Multithread (parallel) to the database and reads the records from 100 tables. The question is can the server read data with 250KB per second from each Table (Parallel and at the same time. I mean Real-time)? In other word, 250KB * 100 = 25MB per second from DB with 100 socket connections? I test it with Corei5 CPU - 16GB Ram but it works just for 150KB.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…