Michael Galloway wrote: > On Wed, Jan 02, 2008 at 04:20:12PM +0100, Bruno Friedmann wrote: >>> With the purpose of gathering facts: are these results repeatable? >>> >> In the same way of idea that Dan. >> >> This could be have to do with the database server having to much record to >> store. >> What and where are the db server ? >> How is the load on it, did you use the delay-insert feature (if so where the >> tmp file is created ? ) >> >> > > 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 Has a vacuum analyse been run on the Bacula database, either manually or through auto-vacuum? What OS is that running on? Is it on the same machine as bacula-sd/bacula-dir? -- 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
