Re: [Bacula-users] postgresql performance

2005-09-24 Thread Arno Lehmann
Hello, On 24.09.2005 19:25, Baldur Norddahl wrote: Hi, I switched from Sqlite to Postgresql. Performance was horrible until I turned fsync off. I suspect that bacula is inserting data about each file as a seperate transaction. As far as I know, you're right. Something like this: begin

[Bacula-users] postgresql performance

2005-09-24 Thread Baldur Norddahl
Hi, I switched from Sqlite to Postgresql. Performance was horrible until I turned fsync off. I suspect that bacula is inserting data about each file as a seperate transaction. Something like this: begin; insert into file values (...); commit; Or actually it is probably just running with au