9 ms·
Introduce intermediate server which accepts multiple requests and groups them into single batch requests. With enough trickery you can even implement it using
by vbezhenar 4y ago
Introduce intermediate server which accepts multiple requests and groups them into single batch requests.
With enough trickery you can even implement it using postgres wire protocol, I guess, so it'll be transparent.
- cbrewster 4y agoNow you need to batch your requests to your intermediate server
- yamtaddle 4y agoNo, you don't. You have one per 100 nodes or whatever. Not a single one for all nodes to talk to.
- mjb 4y agoBut why? Why have an additional component if your database can do it?
- vbezhenar 4y agotwawaaay claimed that similar approach allowed him to improve throughput by factor of 50. Apparently database couldn't do it efficiently in that case.
- deleted 4y ago[deleted]