> 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. -- 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.
