On this page

Suggestion 3.5: Preventing Simultaneous Updates or Deletions of the Same Row in a Row-store Table
Suggestion 3.6: Avoiding Frequent or Simultaneous UPDATE and DELETE Operations on Column-store Tables

Show all

Help Center/ GaussDB(DWS)/ Standard Data Warehouse (8.1.3.x)/ GaussDB(DWS) Development Design Specifications/ GaussDB(DWS) SQL Statement Development Specifications/ UPDATE and DELETE Operations

UPDATE and DELETE Operations

Updated on 2024-12-19 GMT+08:00

View PDF

Suggestion 3.5: Preventing Simultaneous Updates or Deletions of the Same Row in a Row-store Table

NOTE:

Impact of rule violation:

Concurrent UPDATE and DELETE operations on row-store tables may cause row lock blockage and distributed deadlocks, which can lead to service errors and performance degradation.

Solution:

Group UPDATE and DELETE operations by primary key or distribution column. Perform parallel operations between groups while keeping operations within a group serial.

Suggestion 3.6: Avoiding Frequent or Simultaneous UPDATE and DELETE Operations on Column-store Tables

NOTE:

Impact of rule violation:

Frequent UPDATE and DELETE operations on column-store tables can result in CU bloat, leading to large space occupation and decreased access performance.
Concurrent UPDATE and DELETE operations on row-store tables may cause row lock blockage and distributed deadlocks, which can lead to service errors and performance degradation.

Solution:

Design tables with frequent UPDATE and DELETE operations as row-store tables.
Group UPDATE and DELETE operations by primary key or distribution column. Perform parallel operations between groups while keeping operations within a group serial.

Parent topic: GaussDB(DWS) SQL Statement Development Specifications

Previous topic: INSERT Operation

Next topic: SELECT Operation

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback