Bill Moran wrote: > In response to Bacula User <[EMAIL PROTECTED]>:
>> My untuned postgres is too slow. I'm researching ways to speed it up. If >> you have pointers, please share. > > Can you replace 7.4 with 8.2? There are a LOT of performance improvements > in 8.2 over 7.4. I'll second that - 7.4 seems to crop up every so often on the PostgreSQL performance list for all the wrong reasons. It's definitely the first thing to try. As a debugging option, in the postmaster's postgresql.conf file I have something like this on my 8.x installations: log_destination = 'stderr' redirect_stderr = on log_min_duration_statement = 1000 This will log statements that take more than 1 second into files in the postmaster's pg_log directory - having a look at that should show you what's eating up all the time (I think you need to restart the database if you change these). If in the end it turns out the bottleneck is hardware not software related, you might want to consider investing in a battery-backed RAID card so that you can safely switch on write caching and make insert latencies drop like a stone. - Geoff ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
