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® 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
