Re: Postgres Analog of Oracle APPEND hint

[Jayadevan M <maymala.jayadevan@xxxxxxxxx>]

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 

Regards,

Jayadevan