Re: PARALLEL CTAS - Mailing list pgsql-sql

From Erik Brandsberg
Subject Re: PARALLEL CTAS
Date
Msg-id CAFcck8HhsTh70ZjQEuvm2kfx0LULJAZR3NZNHvSEX1Y5BaxAMg@mail.gmail.com
Whole thread Raw
In response to PARALLEL CTAS  (Shane Borden <sborden76@gmail.com>)
Responses Re: PARALLEL CTAS
List pgsql-sql
Copy operations are by far the most efficient way to do bulk loads.  The fdw extension isn't very efficient based on prior experience.

On Mon, Dec 12, 2022 at 11:17 AM Shane Borden <sborden76@gmail.com> wrote:
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?


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

pgsql-sql by date:

Previous
From: Shane Borden
Date:
Subject: PARALLEL CTAS
Next
From: Shane Borden
Date:
Subject: Re: PARALLEL CTAS