Michael Galloway wrote: > On Wed, Jan 02, 2008 at 10:29:36AM -0500, Dan Langille wrote: >>> the db server is the bacula server, its postgres at: >>> >>> # /usr/local/pgsql/bin/postgres -V >>> postgres (PostgreSQL) 8.2.5 >>> >>> and i did not use the delay-insert feature. is there a reference url to >>> this? the load on things >>> seemed resonable. running a load average of around 1.5 or so. server is >>> dual dual core opteron, >>> 8GB ram, lot of swap. >> I think delay-insert refers to batch insert. It is enabled by default. >> >> http://www.bacula.org/rel-manual/Installi_Configur_PostgreS.html >> > > thanks, > >> Has a vacuum analyse been run on the Bacula database, either manually or >> through auto-vacuum? >> > > nope. what does vacuum analsys do?
It is a PostgreSQL command. It updates the statistics used by the query planner. I do not know that this will affect things, but it is a good thing to do on a regular basis. -- Dan Langille BSDCan - The Technical BSD Conference : http://www.bsdcan.org/ PGCon - The PostgreSQL Conference: http://www.pgcon.org/ ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
