My questions are: (1) Does the MVCC architecture introduce significant
delays between insert by a thread and visibility by other threads
As said by others, once commited it is immediately visible to all
(2) Are there any available benchmarks that can measure this delay?
Since you will not
Steve Wong wrote:
> (1) Does the MVCC architecture introduce significant delays
> between insert by a thread and visibility by other threads (I am
> unclear about how multiple versions are "collapsed" or reconciled,
> as well as how different query threads are seeing which version)?
As soon as
On Oct 25, 2010, at 2:46 PM, Steve Wong wrote:
> Hi experts,
>
> I have a (near) real-time application in which inserts into the database
> needs
> to be visible to queries from other threads with minimal delay. The inserts
> are
> triggered by real-time events and are therefore asynchronous
