Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: TiDB与Greenplum7的OLTP性能
[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots / Logs / Monitoring]
As mentioned, for multi-table joins with approximately 1 billion rows per table, which has better TPC-C performance, TiDB or Greenplum7?
Greenplum7 is not widely used in China, I’m not very familiar with it.
Normally speaking, it might be GP.
TiDB should be superior to GP.
Is there an official TPC test result?
It feels like GP is still used under normal circumstances.
In most OLTP scenarios, TiDB has greater advantages. As an established player, Greenplum has advantages in OLAP.
TiDB should be compared to Greenplum 7.
I don’t understand this thing called Greenplum.
TiFlash has more than twice the performance of GP6. Unless GP7 can make a huge improvement, it stands no chance.
P.S: Currently, the fastest in AP scenarios are Doris/StarRocks. Not sure when TiFlash will be able to reach this performance 
As for TP performance, TiDB should outperform GP in high concurrency scenarios. However, if it’s about multi-table joins with primary keys, it’s hard to say since GP supports foreign keys.
This is the official comparison of TiDB v5.4 and GP 6.15.0 using TPC-H. TiDB v5.4 outperforms GP 6.15.0. GP7 is based on Postgre v12, which has a significant performance improvement over GP6’s pg v9.4. At the same time, TiDB v7.x’s TiFlash also has substantial performance improvements over previous versions. Both have similar applications of new technologies such as vectorized engines, making it difficult to accurately judge the performance superiority between TiDB v7 and GP7. Generally, their performance should be similar, or TiDB v7 might be slightly better. TiDB’s greater advantage lies in its HTAP integration.
Greenplum has advantages in OLAP, and the performance of the new version might be better.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
|
username: Trouble
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: