Re: Interesting paper: Contention-Aware Lock Scheduling

2018-04-13 Thread Garym
I did testing on 9.6 and 10. Outside of slaves at distance, it does demonstrate consistent OOA operation whether intentional/enforced or not. :) Sent from my iPad > On Apr 13, 2018, at 11:50 AM, Evgeniy Shishkin wrote: > > > >> On Apr 13, 2018, at 20:46, Garym wrote

Re: Interesting paper: Contention-Aware Lock Scheduling

2018-04-13 Thread Garym
LDFS does show improvements for certain workloads, however it sacrifices temporal order and may interfere with historical analytics. If applications can tolerate ambiguous order of processing, it shows good gains. Sent from my iPad > On Apr 13, 2018, at 11:14 AM, Konstantin Knizhnik > wrote:

Is there a cache consistent interface to tables ?

2018-02-08 Thread Garym
Hi, This is an odd request for help. I'm looking to expose an interface so an external app can insert to a table while maintaining cache consistency and inserts be promoted via wal. I need to support about 100k+ inserts/sec from a sensor data stream. It simply won't work using sql queries. I