Hi Everybody.
As well, a few have been asking about multi-threading.
Marc has told me about the past discussions on it.
I'm interested in re-opening some discussion on it, as we may eventually
have funding to do help with it.
Would it not be advantageous to use threading in the PostgreSQL backend?
Many servers make use of threading to increase throughput by performing
IO and computations concurrently. (While one thread is waiting for the
disk to respond to an IO request, another processes the last chunk of data).
As well, threads tend to have a lower process switching time, so that may
help a bit on heavily loaded systems. (Of course, it would tend to be a
combination of forking and threading. Threading benefits have limits).
Any thoughts?
Duane