nconway@klamath.dyndns.org (Neil Conway) writes:
> However, I think using threads is only a good idea if it gets us a
> substantial performance increase. From what I've seen, that isn't the
> case; and even if the time to create a connection is a bottleneck, there
> are other, more conservative ways of improving it (e.g. pre-forking,
> persistent backends, and IIRC some work Tom Lane was doing to reduce
> backend startup time).
The one place where it could be a clear win would be in splitting
single very large queries over multiple CPUs. This would probably
require an even larger redesign of the whole system than moving to a
query-per-thread rather than per-process model. I think "real"
multi-master replication and clustering is a better goal in the short
term...
-Doug
--
Let us cross over the river, and rest under the shade of the trees. --T. J. Jackson, 1863
