I forgot about the link I found about this:
http://www.mail-archive.com/pgsql-performance@postgresql.org/msg19584.html
what do you think?
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
