Re: [Bacula-users] Database performance issue

2011-07-22 Thread Bruno Friedmann
On 07/21/2011 04:40 AM, Dan Langille wrote: > On Jul 19, 2011, at 5:45 PM, Roy Sigurd Karlsbakk wrote: > >>> Starting a file-based restore job, this led to postgresql spending a >>> full 15 minutes in a query. Any idea what can be done to fix this? >>> >>> http://paste.ubuntu.com/647576/ has a ful

Re: [Bacula-users] Database performance issue

2011-07-20 Thread Dan Langille
On Jul 19, 2011, at 5:45 PM, Roy Sigurd Karlsbakk wrote: >> Starting a file-based restore job, this led to postgresql spending a >> full 15 minutes in a query. Any idea what can be done to fix this? >> >> http://paste.ubuntu.com/647576/ has a full explain/analyze of the >> query, but so far, I ha

Re: [Bacula-users] Database performance issue

2011-07-19 Thread Roy Sigurd Karlsbakk
> Starting a file-based restore job, this led to postgresql spending a > full 15 minutes in a query. Any idea what can be done to fix this? > > http://paste.ubuntu.com/647576/ has a full explain/analyze of the > query, but so far, I haven't figured out where the problem is. Anyone > with an idea o

[Bacula-users] Database performance issue

2011-07-19 Thread Roy Sigurd Karlsbakk
Hi all Starting a file-based restore job, this led to postgresql spending a full 15 minutes in a query. Any idea what can be done to fix this? http://paste.ubuntu.com/647576/ has a full explain/analyze of the query, but so far, I haven't figured out where the problem is. Anyone with an idea of