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
