Search Postgresql Archives

Re: Postgres Analog of Oracle APPEND hint

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux