One thing I can't comment on is the impact mod_perl could have on what you're trying to achieve. I've never used mod_perl, but using it is a way to increase the performance of scripts running through your webserver - and it gives you access to webserver internals.
The only issue we had when using mod_perl with a different database server (MySQL) is that you need to pay closer attention to your managing of the connection objects. Since mod_perl keep variables in memory, a connection object gets created once and later on when it's used an hour later, the database server has dropped it. So you either need to trap expired connections and reestablish them or declare the variable and force a reconnect on each run.
Rob
