Writing Data to GaussDB(DWS) Is Slow and Client Data Is Stacked

Symptom

Writing data to GaussDB(DWS) is slow and the client data is stacked.

Possible Causes

If a single INSERT INTO statement is used to write data to a database, the client may encounter a bottleneck. INSERT is the simplest data writing method and is applicable to scenarios with small data volumes and low concurrency.

Handling Procedure

If data writing is slow, use either of the following methods to rectify the fault:

• Select another more efficient data import mode, for example, COPY.

  For details about the import modes, see Import Modes.

• Increase the concurrent client requests.