Data Write to DWS Becomes Slower
Cause Analysis
Data write in seconds is normal. If it takes more than 5 seconds to write thousands of data records, the performance deteriorates.
Solution
If a DWS table is frequently accessed, the write performance deteriorates. In this case, optimize DWS, for example, periodically use the analyze plan table and VACUUM FULL.