This value depends on the traffic of your site, the more traffic the more seconds to retain the connection, I’d recommend setting a relatively small value like 60 and tuning it accordingly to the usage pattern.
Edit (2018):
Like @jcyrss pointed out, this method has its quirks, for future reference I’d recommend handing out pooling to something like pgbouncer instead.