On Thursday 14 December 2006 01:27, Gabriele Bulfon wrote: > I forgot about the link I found about this: > http://www.mail-archive.com/pgsql-performance@postgresql.org/msg19584.html > what do you think?
As I mentioned, this has nothing to do with the speed of writing on the tape. It does slow down the overall speed, and if you are using the throughput measures printed by Bacula, you are using the overall speed and not the speed writing to the tape. That speed, if I am not mistaken, is printed in version 1.39.x The database speed up code has been working for PostgreSQL for a month or so, and give very good speedup. However it will not be in Bacula until a later version. > Gabriele Bulfon - Sonicle S.r.l. > Tel +39 028246016 Int. 30 - Fax +39 028243880 > Via Felice Cavallotti 16 - 20089, Rozzano - Milano - ITALY > http://www.sonicle.com > ---------------------------------------------------------------------------------- > Da: Kern Sibbald <[EMAIL PROTECTED]> > A: bacula-users@lists.sourceforge.net > Cc: Ryan Novosielski <[EMAIL PROTECTED]> Gabriele Bulfon <[EMAIL PROTECTED]> Bill Moran <[EMAIL PROTECTED]> > Data: 13 dicembre 2006 19.31.20 CET > Oggetto: Re: [Bacula-users] Postgres slow because of autocommit > On Wednesday 13 December 2006 18:46, Ryan Novosielski wrote: > > Kern Sibbald wrote: > > > > >> Moving the DB on another x86 / amd machine solve the problem, but I > anyway > > > can reach a maximum rate of 8-10Mb/sec, that is not the maximum transfer > rate > > > I may have on those LTO drives (that may run from 15 to 60 to 120 Mb/s > > > depending on the version). > > > > > > Try moving your tape drive to a "modern AMD or x86 machine" :-) > > > > I'm inclined to believe that's not necessary. > I was being a bit cute ... > > My director machine is a > > Sun UE450 3x296MHz, and the performance I get seems to be acceptable. My > > example numbers are 1213K/s (including spooling), or 41 mins for 3GB > > with a DAT72 drive. Is this slow? > Not for a DAT, but it is horrible for any LTO particularly if it is an LTO-3. > > I use MySQL4 on my machine. > > > > -- > > ---- _ _ _ _ ___ _ _ _ > > |Y#| | | |\/| | \ |\ | | | Ryan Novosielski - Systems Programmer III > > |$&| |__| | | |__/ | \| _| | [EMAIL PROTECTED] - 973/972.0922 (2-0922) > > \__/ Univ. of Med. and Dent.| IST/AST - NJMS Medical Science Bldg - C630 > > > ------------------------------------------------------------------------- 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
