On Monday, November 6, 2017 at 10:57:37 PM UTC+1, Adam G wrote: > > I'm trying to understand how to tune the Sequel *max_connections* value > when connecting to a postgres database. The docs say "The maximum size of > the connection pool (4 connections by default on most databases)". What at > the best practices for tuning this number? > > More specifically for my use case, I have multiple machines running a > single Sidekiq process that's creating 25 threads. From time to time I'm > seeing Sidekiq pool timeouts. >
4 is probably too small for 25 threads if they are accessing the database on a regular basis. Try 15 and see if that fixes the issue. Note that in general, this type of thing is application specific, so you'll have to try different values and see what works best for you. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
