Bruce Momjian wrote:
> So, by my logic, if we have 100 backends all doing updates, we will
need
> 10 * 100 or 1000 writer processes or threads to keep up with that
load.
> That seems quite excessive to me from a context switching and process
> overhead perspective.
Quick point:
A single process using multiple threads dedicated to writing is an
excellent optimization target on the win32 platform, (and if it is
similarly useful on other platforms, so much the better). To my way of
thinking, this is an ideal approach in the long run.
Multiple processes scheduling writes (even it is only 10), IMO, is a bad
idea because of the way process management on win32 works for various
reasons.
Merlin
