It may be that we would get better performance from roxie on multi-socket machines if we ran two processes on each machine, each bound to a single socket.
Not sure how we would manage to have both listen on the same port though. Also, it may be that the query affinity option that is already available would provide much of the same benefit (if we enabled it...)
Conclusion
None
Activity
Show:
Richard Chapman
August 24, 2016 at 9:32 AM
Mark, something to investigate at the same time as looking at the UDP performance perhaps. If the existing query affinity code gets us most of the way there without having to worry about how to direct traffic between the two processes from a single listening port, then that would be a much simpler solution (just requires enabling the option, I think).
Pinned fields
Click on the next to a field label to start pinning.
It may be that we would get better performance from roxie on multi-socket machines if we ran two processes on each machine, each bound to a single socket.
Not sure how we would manage to have both listen on the same port though. Also, it may be that the query affinity option that is already available would provide much of the same benefit (if we enabled it...)