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 <remi9898@xxxxxxxxx> 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 <rgravens@xxxxxxxxx> wrote:All,Using PostgreSQL 13.1I 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
