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
