On Fri, 26 Mar 2010, Xavier Romero wrote:
> Hi all,
>
> I've detected serious problems on my PostgreSQL to manage following query
> SELECT Filename.FilenameId,File.FilenameId FROM Filename LEFT OUTER JOIN File
> ON (Filename.FilenameId=File.FilenameId) WHERE File.FilenameId IS NULL LIMIT
> 3
I do not think you should be running dbcheck and bacula at the same
time. Turn off the director, run dbcheck, turn on the director. If
dbcheck is running slow, you may need to create a few extra temporary
indexes to speed it up.
On 3/26/2010 10:36 AM, Xavier Romero wrote:
Hi all,
I've de
Hi all,
I've detected serious problems on my PostgreSQL to manage following query
SELECT Filename.FilenameId,File.FilenameId FROM Filename LEFT OUTER JOIN File
ON (Filename.FilenameId=File.FilenameId) WHERE File.FilenameId IS NULL LIMIT
30
Causing the whole Bacula to stop working since it n
