> So an average backend only processes ~ 5 queries before exiting?
>
> 7.3 has reduced some of those startup costs a little, so if you're still
> on 7.2 then an update might help. But I'd strongly recommend getting
> connection re-use in place before you go off and buy hardware.
I've been fooling around with some connection pooling, and it hasn't
make the sort of difference we're looking for. Going from 3 queries per
back-end to 100 queries per backend made only about a 20% difference.
While that's nothing to scoff at, we're looking for at least a 100%
improvement. Either way, the connection pooling WILL be put in place, but
I'm certainly not counting on it preventing the need for a hardware
upgrade.
steve