how to speed up write data to greenplum

[wonb168]

I use duckdb to query greenplum, and after a series of calculations, I write the results back to greenplum. However, the write-back speed is very slow. Is there any way to speed it up? In addition, Greenplum tables require the setting of distribution keys, column storage, and compression. How can this be achieved using postgres_scanner?

[sibarras]

Facing the same issue. Load times can go up to 4 minutes for a small table with 3 columns and 3 rows.