Re: [PERFORM] Optimicing Postgres for SunSolaris10 on V240

2006-11-18 Thread Marc Cousin
Hi... Bacula does no transaction right now, so every insert is done separately with autocommit. Moreover, the insert loop for the main table is done by several individual queries to insert data in several tables (filename, dir, then file), so this is slow. There's work underway to speed that up,

Re: [PERFORM] Optimicing Postgres for SunSolaris10 on V240

2006-11-17 Thread Josh Berkus
Berner, First, I've corrected you e-mail so that it goes to the list, and not to me directly. I use my PostgreSQL 8.0.4 as Catalogue-Database for Bacula. Bacula is a Backupsoftware. Yes. The lead contributor to Bacula is a active PostgreSQL project participant; I'll see if he'll look into