I agree that it's often unnecessary to pool database connections, especially if the heavyweight Web servers are configured to use a lightweight front-end server as recommended in the
mod_perl guide. I also agree that it's difficult to do.
DBD::Proxy looks like an interesting attempt to deal with this, although its documentation mentions that its
connect_cached method, which pools connections using an intermediary process,
is new and still experimental. It might be worth a look, though.