In response to Bacula User <[EMAIL PROTECTED]>: > > I am using freebsd 6.1, bacula 1.38.11_1, and postgresql-server-7.4.13_1. > Each night I dump 913,157,728,765 bytes of 5,395,281 files to tape. I > spool data and attributes. I will need to almost triple this amount to > deploy bacula. Data goes to tape in under 16.5 hours, but attributes > continue going into the catalog for over 13 hours afterwards. In other > words, I'm still writing the previous night's data to the database when > the new day's backup cycle starts. I never get a chance to get an ascii > dump of the db before the next backup cycle begins. > > 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. You should probably join the PostgreSQL performance mailing list: http://www.postgresql.org/community/lists/subscribe There is a good guide here: http://www.varlena.com/GeneralBits/Tidbits/perf.html Generally speaking, you're dealing with lots of inserts. To speed them up you're going to need very fast disks. You'll probably also benefit from increasing checkpoint_segments and checkpoint_timeout (see http://www.postgresql.org/docs/8.2/static/wal-configuration.html) Make sure you vacuum and analyze frequently. Your scenario may benefit from using the autovacuum daemon. > Furthermore, each night has many errors > like the following. What do these mean and how do I fix them? They are normal operation. Bacula creates a number of temp tables and deletes them when it's done with them. To ensure sane recovery from a crash, Bacula tries to delete them before using them, just in case they were left over from a crash. There are ways to do this in PostgreSQL without producing these errors, but I don't think there's a database- independent way of doing this without causing these errors. The short answer is they're nothing to worry about. > > postgres[19278]: [324-1] ERROR: index "delinx1" does not exist > postgres[19278]: [325-1] ERROR: index "delinx1" does not exist > postgres[19278]: [326-1] ERROR: table "delcandidates" does not exist > postgres[19278]: [327-1] ERROR: index "delinx1" does not exist > postgres[19278]: [328-1] ERROR: index "delinx1" does not exist > postgres[19278]: [329-1] ERROR: table "delcandidates" does not exist > postgres[19278]: [330-1] ERROR: index "delinx1" does not exist > postgres[19278]: [331-1] ERROR: index "delinx1" does not exist > postgres[19278]: [332-1] ERROR: table "delcandidates" does not exist > postgres[19278]: [333-1] ERROR: index "delinx1" does not exist > postgres[19278]: [334-1] ERROR: index "delinx1" does not exist > postgres[19278]: [335-1] ERROR: table "delcandidates" does not exist > postgres[19278]: [336-1] ERROR: index "delinx1" does not exist > postgres[19278]: [337-1] ERROR: index "delinx1" does not exist > postgres[19278]: [338-1] ERROR: table "delcandidates" does not exist > postgres[19278]: [339-1] ERROR: index "delinx1" does not exist > postgres[19278]: [340-1] ERROR: index "delinx1" does not exist > postgres[19278]: [341-1] ERROR: table "delcandidates" does not exist > postgres[19278]: [342-1] ERROR: index "delinx1" does not exist > postgres[19278]: [343-1] ERROR: index "delinx1" does not exist > postgres[19278]: [344-1] ERROR: table "delcandidates" does not exist > postgres[19278]: [345-1] ERROR: index "delinx1" does not exist > postgres[19278]: [346-1] ERROR: index "delinx1" does not exist > postgres[19278]: [347-1] ERROR: table "delcandidates" does not exist > postgres[19278]: [348-1] ERROR: index "delinx1" does not exist > postgres[19278]: [349-1] ERROR: index "delinx1" does not exist > > Thank you for your help. Bacula is well on its way to replacing our > current method of madness. I just need to sort a few more things out. -- Bill Moran Collaborative Fusion Inc. ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
