Re: [bareos-users] Super slow query after upgrade to 17.2 from 16.2

2018-01-25 Thread jsfrerot
Le mardi 23 janvier 2018 16:26:47 UTC-5, Stephan Duehr a écrit : > Hi, > > that looks like the query being run for accurate backup. > I wonder why it's slower after the upgrade, as it's one table less for the > join. > This kind of problem with accurate has also been seen with the Bareos 16.2 DB

[bareos-users] Super slow query after upgrade to 17.2 from 16.2

2018-01-22 Thread jsfrerot
Hi, After the upgrade to 17.2.4 (21 Sep 2017) I noticed the following sql query: SELECT Path.Path, T1.Name, T1.FileIndex, T1.JobId, LStat, DeltaSeq , Fhinfo, Fhnode FROM ( SELECT FileId, Job.JobId AS JobId, FileIndex, File.PathId AS PathId, File.Name AS Name, LStat , DeltaSeq, Fhinfo, Fhnode, Jo