Horton

PARALLEL CTAS

Shane Borden <sborden76@gmail.com>

View thread View on postgr.es
From: Shane Borden <sborden76@gmail.com>
To: pgsql-sql@lists.postgresql.org
Date: 2022-12-12T16:16:49Z
Lists: pgsql-sql 
Based on testing thus far, it appears that the only way to get a bulk load operation (similar to oracle) would be to use the COPY command or to use multiple connections and break up the inserts across connections.  I did see a possibility of using the postgres_fdw extension and use the batch functionality, but I haven’t tested that yet.

Does anyone know the status of this feature / patch that was discussed in this link?

https://www.postgresql.org/message-id/CAJcOf-cXnB5cnMKqWEp2E2z7Mvcd04iLVmV%3DqpFJrR3AcrTS3g%40mail.gmail.com

Is there a way in PostgreSQL to parallelize a CTAS statement similar to how you can do it in Oracle?

---

Thanks,


Shane Borden
sborden76@gmail.com