> > 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
