We will probably tweak this knob some more -- i.e., what is the sweet spot between 1 and 100? Would it be higher than 50 but less than 100? Or is it somewhere lower than 50?
I would love to know the answer to this as well. We have a similar situation, pgbouncer with transaction log pooling with 140 connections. What is the the right value to size pgbouncer connections to? Is there a formula that takes the # of cores into account?