Re: Postgres Analog of Oracle APPEND hint

>
> Using PostgreSQL 13.1
>
> I am new to PostgreSQL transitioning from Oracle. One of the many Oracle
> tricks I learned is that large inserts can be sped up by adding the direct
> path load hint /*+APPEND*/ . I am faced with having to perform many large
> inserts (100K->100M rows) in my PostgreSQL database.
>
> My questions are:
>
> - Is there something comparable within the PostgreSQL community
> edition product?
> - Are my only options to un-log the table and tune instance memory
> parameters?
>
>
> I remember trying this some time ago. It is not part of the PG community
edition. Still, worth a look -
https://ossc-db.github.io/pg_bulkload/pg_bulkload.html
<https://ossc-db.github.io/pg_bulkload/pg_bulkload.html>

Regards,
Jayadevan