On 11/03/16 19:47, Douglas K, Rand wrote: >> On 11/03/2016 03:58 PM, Douglas K. Rand wrote: >>> I'm a little startled at how many connections Bareos makes to >>> Postgres. We have currently have 88 backup jobs scheduled to start >>> each day in the evening. The max current jobs that we run is 10. >>> For this Bareos makes about 100 separate connections to Postgres, >>> which seems quite high. > > On 11/3/16 11:44 AM, Stephan Dühr wrote: >> that looks like too many connections for 10 concurrent jobs. >> Do you have spooling (Data or Attribute Spooling) enabled? > > I enabled Attribute Spooling and there is no change. It spikes up to 99 > connections and then as the jobs start finishing the count reduces. Our > backups kick off at 19:30, here are the Postgres connection counts per > minute around then: > > 2016-11-03.18:59:00: 1 > 2016-11-03.19:30:00: 11 > 2016-11-03.19:31:00: 99 > 2016-11-03.19:32:00: 93 > 2016-11-03.19:33:00: 88 > 2016-11-03.19:34:00: 87 > 2016-11-03.19:35:00: 85 > 2016-11-03.19:36:00: 82 > 2016-11-03.19:37:00: 81 > 2016-11-03.19:38:00: 79 > > Here are how many jobs completed in each minute: > 19:30: 1 > 19:31: 5 > 19:32: 5 > 19:33: 1 > 19:34: 2 > 19:35: 3 > 19:36: 1 > 19:37: 1 > 19:38: 2 > > There seems to be a correlation between the two lists.
And as a follow up, I recently upgraded my director and storage daemon to 16.2.4 and the number of Postgres database connections stayed the same. Pretty much one per job. -- You received this message because you are subscribed to the Google Groups "bareos-users" 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]. For more options, visit https://groups.google.com/d/optout.
