Since INSERT /*+APPEND*/ is generally used when bulk loading data into Oracle from external files you should probably look at the PostgreSQL COPY command (https://www.postgresql.org/docs/13/sql-copy.html) and additional utilities like pg_bulkload (https://github.com/ossc-db/pg_bulkload) .
On Thu, Feb 25, 2021 at 9:45 AM Rumpi Gravenstein <rgrav...@gmail.com> wrote: > All, > > 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've googled for this and can't find a definitive statement on this > point. > > -- > Rumpi Gravenstein >
