Re: [Bacula-users] PostgreSQL & dbcheck query

Subject:	Re: [Bacula-users] PostgreSQL & dbcheck query
From:	Alan Brown <ajb2 AT mssl.ucl.ac DOT uk>
To:	Xavier Romero <XRomero AT nexica DOT com>
Date:	Mon, 29 Mar 2010 12:01:11 +0100 (BST)

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


What are your work_mem and maintenance_work_mem parameters set to?




------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
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>
[Bacula-users] PostgreSQL & dbcheck query, Xavier Romero Re: [Bacula-users] PostgreSQL & dbcheck query, Brian Debelius Re: [Bacula-users] PostgreSQL & dbcheck query, Alan Brown <=