From: Shane Borden <sborden76@gmail.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_CF9DF40A-6174-424F-BA5E-A0158A4DD982"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.200.110.1.12\))
Subject: PARALLEL CTAS
Message-Id: <C1FD3065-84ED-47BA-BDA1-16B6A7E05EE7@gmail.com>
Date: Mon, 12 Dec 2022 11:16:49 -0500
To: pgsql-sql@lists.postgresql.org
Archived-At: 
 <https://www.postgresql.org/message-id/C1FD3065-84ED-47BA-BDA1-16B6A7E05EE7%40gmail.com>
Precedence: bulk


--Apple-Mail=_CF9DF40A-6174-424F-BA5E-A0158A4DD982
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

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=E2=80=99t 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


--Apple-Mail=_CF9DF40A-6174-424F-BA5E-A0158A4DD982
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"overflow-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;"><div>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. =
&nbsp;I did see a possibility of using the postgres_fdw extension and =
use the batch functionality, but I haven=E2=80=99t tested that =
yet.</div><div><br></div><div>Does anyone know the status of this =
feature / patch that was discussed in this =
link?</div><div><br></div><div><a =
href=3D"https://www.postgresql.org/message-id/CAJcOf-cXnB5cnMKqWEp2E2z7Mvc=
d04iLVmV%3DqpFJrR3AcrTS3g%40mail.gmail.com">https://www.postgresql.org/mes=
sage-id/CAJcOf-cXnB5cnMKqWEp2E2z7Mvcd04iLVmV%3DqpFJrR3AcrTS3g%40mail.gmail=
.com</a></div><div><br></div><div>Is there a way in PostgreSQL to =
parallelize a CTAS statement similar to how you can do it in =
Oracle?</div><br><div>
<div>---<br><br>Thanks,<br><br><br>Shane =
Borden<br>sborden76@gmail.com</div>

</div>
<br></body></html>=

--Apple-Mail=_CF9DF40A-6174-424F-BA5E-A0158A4DD982--