+==============================================================================================+ | Node ID8(@), IP | CPUs | Heap Used | CPU Load | Up Time | Size | Hi/Mi/Rd/Wr | +==============================================================================================+ | 0F0AAF99(@n0), 127.0.0.1 | 8 | 54.50 % | 3.23 % | 00:13:13:49 | 3000000 | Hi: 0 | | | | | | | | Mi: 0 | | | | | | | | Rd: 0 | | | | | | | | Wr: 0 | +----------------------------------------------------------------------------------------------+
I followed your hints. Actually, client doesn't require such many memory as before - thanks for it. When it comes to configuration of server, I also followed your hints, results: Querying is done by JDBC Client. In ignite and postgresql I have single index on column A. Ignite: SELECT * FROM table WHERE A > 1345 takes 6s. Postgres: SELECT * FROM table WHERE A > 1345 takes 4s. As you can see, postgres is still bettter than Ignite. I show you significant fragments of my configuration: http://pastebin.com/EQC4JPWR And xml for server file: http://pastebin.com/enR9h5J4 Try to consider why postgresql is still better, please.
