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

Re: [Bacula-devel] Alternative DB structures-Porposal

On Sep 24, 2008, at 4:56 PM, John Huttley wrote:

> Ok I've got a better handle on this.
> First, a side issue that anyone dealing with PG needs to know about.
> PG uses MVCC. This allows unlimited transactions in flight and is  
> lock-free.
> So it has great concurrency.
> But there is a draw back. Edit a row, and we get another version of  
> that row.
> Any indexes on that table have to updated, even if the field you are  
> updateing
> is not indexed (!!!!!!!!!)

No need for !!!!!!!!!.  :)  Of course great concurrency has a price.  :)

The goal, if we can, is to avoid any "insert update... update"  

Any tests you do, I can help by duplicating the run on my servers.   
Being able
to duplicate your test results will help decide go/no-go with respect  
to design

Dan Langille

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
Bacula-devel mailing list

This mailing list archive is a service of Copilot Consulting.