[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] Alternative DB proposal


Yuri Timofeev wrote:
> Good work!
> But...
> I think the test is not quite correct. ;)
> I am talking about the command "COPY" in PostgreSQL.
> 
> In other words, I think that COPY and INSERT performed differently.
> "COPY" must be implemented faster than individual "INSERT" into real Bacula Job.
> 
> I may be wrong.
> 
> To make the most correct test, we must take the bacula source code and
> based on it to make gen_filetable.c, for example.
> We must  use INSERTs instead COPY.

INSERT in a transaction should perform "similar" to "copy". You could 
even do a insert with multiple tuples. But single inserts will 
absolutely be slower than copy due to parsing/copying and transaction 
overhead.

-- 
Jesper

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-devel mailing list
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.