Unfortunately, I am not looking to load from an external source. My process is moving data from source PostgreSQL tables to target PostgreSQL tables.
On Thu, Feb 25, 2021 at 10:36 AM Mark Johnson <remi9...@gmail.com> wrote: > 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 >> > -- Rumpi Gravenstein
