Re: PARALLEL CTAS

Поиск
Список
Период
Сортировка
От Erik Brandsberg
Тема Re: PARALLEL CTAS
Дата
Msg-id CAFcck8HhsTh70ZjQEuvm2kfx0LULJAZR3NZNHvSEX1Y5BaxAMg@mail.gmail.com
обсуждение исходный текст
Ответ на PARALLEL CTAS  (Shane Borden <sborden76@gmail.com>)
Ответы Re: PARALLEL CTAS  (Shane Borden <sborden76@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Shane Borden
Дата:
Сообщение: PARALLEL CTAS
Следующее
От: Shane Borden
Дата:
Сообщение: Re: PARALLEL CTAS