The answer is in my opinion incomplete.

If you use PostgreSQL then pooling is enabled just with some piece of additional software. So if you really want to use a Perl-only solution this software (or may be Apache, but I'm not too competent on this question) would have to do it all by itself.