Post APMo2ASnNsuErg60i8 by seb@ioc.exchange
 (DIR) More posts by seb@ioc.exchange
 (DIR) Post #APMnwZEcN8NrxDnHw8 by seb@ioc.exchange
       2022-11-07T15:40:13Z
       
       0 likes, 0 repeats
       
       @stux @jerry Gents, admire your work and was wondering if you can help me out on something.I'm having a hard time to get my sidekiq service to perform better. Put pgbouncer in the mix but it still only creates around 30 busy when I give it 200 threads. Any idea what else could be constraint for the sidekiq process?
       
 (DIR) Post #APMo0cWi4iznK1BmU4 by cstromblad@ioc.exchange
       2022-11-07T15:50:38Z
       
       0 likes, 0 repeats
       
       @seb @stux @jerry I've got no experience to share unfortunately, but come across this post talking about transactional pools rather than session based.https://masto.host/mastodon-pgbouncer-guide/
       
 (DIR) Post #APMo2ASnNsuErg60i8 by seb@ioc.exchange
       2022-11-07T15:56:03Z
       
       0 likes, 0 repeats
       
       @cstromblad @stux @jerry Yep, that is the guide I followed to setup pgbouncer. pool_mode is set to transaction already.
       
 (DIR) Post #APNDBX8mwC3oepIgiG by vito@botta.social
       2022-11-07T20:48:39Z
       
       0 likes, 0 repeats
       
       @seb @stux @jerry regardless of whether you use #pgbouncer, it’s better not to configure too many threads because they will be competing for the cpu due to the #ruby GVL