BackGround

Greenplum DB is an open-source massively parallel data platform for analytics, machine learning and AI.

Greenplum DB 6.0 is close to release and in GPDB6, Global Deadlock Detector (GDD) is introduced so that DMLS (insert, update, delete) on the same table can be executed concurrently. According to a performance test report by Alibaba:

Alibaba in China has done some initial testing on OSS GP in preperation for Greenplum 6.  Here is the test result:

TEST CASE: Each transaction 3 updates, 1 select, 1 insert
  * Greenplum 5 , Transactions per Second: 15
* Greenplum 6,  Transactions per Second: 2900

An idea just came up to me that using prolog to calculate 24.

Continue reading →