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