...
Oracle offers "direct path load" [1] as the fastest method to populate data after manual file copying. Direct path load can be from both command line utility SQL*Loader to load existing files (resembling Ignite's COPY
command command), and with conventional SQL, such as INSERT
and CREATE TABLE AS SELECT
(CTAS). Major highlights:
...
[1] https://docs.oracle.com/cd/E11882_01/server.112/e22490/ldr_modes.htm#SUTIL009
[2] https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/managing-tables.html#GUID-134D6EB6-219E-4820-AB54-8C60067A8F0F
...
PostgreSQL offers a number of best practices for efficient data load. Dedicated COPY
command exists to bypass SQL parsing and minimize network overhead. Apart from that there are not dedicated features for data load. General recommendations are:
maintenance_work_mem
parameter (buffer for index rebuild routines)max_wal_size
parameterTODO
...