[Paper Reading Preview] Greenplum 6: A Hybrid Database for Transactional and Analytical Workloads

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 【Paper Reading 预告】Greenplum 6:A Hybrid Database for Transactional and Analytical Workloads

| username: YY-ha

This week, Paper Reading will discuss the Greenplum 6 paper!

On July 14th (this Thursday) at 8 PM, join us to hear community user @阿福Chris share “A Hybrid Database for Transactional and Analytical Workloads”~

Content Introduction:

This Paper Reading session will share a paper on Greenplum 6. In the GP6 version, the R&D team considered many optimization methods and designs when integrating AP and TP scenarios. The main content of the Paper Reading includes an introduction to the Greenplum MPP architecture, lock optimization, distributed transaction management, resource isolation, and other parts. These optimization methods significantly improved Greenplum 6’s processing capabilities in mixed workload scenarios, hoping to provide some reference ideas for everyone in database usage and development.

Why share this paper?

As an HTAP database, TiDB’s HTAP capabilities have evolved from TP to TP+AP. In comparison, Greenplum is renowned for its AP capabilities, and its approach is the progression from AP to AP+TP. Through this sharing session, everyone can understand some thoughts on enhancing TP capabilities in analytical distributed databases, facilitating mutual exchange and learning.

Registration link: https://forms.pingcap.com/f/paper-reading-02

| username: Hacker_xUwtuKxa | Original post link

The screenshot is not visible. Please provide the text you need translated.

| username: TiDBer_pig | Original post link

Shared

| username: tidb狂热爱好者 | Original post link

| username: 孙晨航11 | Original post link

Paper Reading is here!

| username: mliaukz | Original post link

I have encountered the same problem. The solution is to add the following configuration to the TiDB configuration file:

[performance]
txn-total-size-limit = 10737418240

This configuration increases the transaction size limit to 10GB.

| username: 索隆爱喝酒 | Original post link

Here it comes!

| username: TiDBer_sao游 | Original post link

| username: TiDBer_dog | Original post link

The default value of tidb_enable_clustered_index is INT_ONLY in version 5.0, which means that only tables with integer primary keys will use clustered indexes by default. If you want to enable clustered indexes for all tables, you need to set this parameter to ON.

| username: TiDBer_徐川 | Original post link

| username: YY-ha | Original post link

Friends upstairs, the points for sharing and interacting with the Paper Reading event poster have been updated. Thank you for helping more people discover the treasure that is the TiDB community~

| username: YY-ha | Original post link

This topic was automatically closed 1 minute after the last reply. No new replies are allowed.