Bacula-users

[Bacula-users] Database performance issue

2011-07-19 16:06:27
Subject: [Bacula-users] Database performance issue
From: Roy Sigurd Karlsbakk <roy AT karlsbakk DOT net>
To: bacula-users <bacula-users AT lists.sourceforge DOT net>
Date: Tue, 19 Jul 2011 22:07:49 +0200 (CEST)
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 how to 
tune this?

Vennlige hilsener / Best regards

roy
--
Roy Sigurd Karlsbakk
(+47) 97542685
roy AT karlsbakk DOT net
http://blogg.karlsbakk.net/
--
I all pedagogikk er det essensielt at pensum presenteres intelligibelt. Det er 
et elementært imperativ for alle pedagoger å unngå eksessiv anvendelse av 
idiomer med fremmed opprinnelse. I de fleste tilfeller eksisterer adekvate og 
relevante synonymer på norsk.

------------------------------------------------------------------------------
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>