Re: Threaded PosgreSQL server

nconway(at)klamath(dot)dyndns(dot)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