From: | Mark Johnson <remi9898(at)gmail(dot)com> |
---|---|
To: | Rumpi Gravenstein <rgravens(at)gmail(dot)com> |
Cc: | PostgreSQL <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Postgres Analog of Oracle APPEND hint |
Date: | 2021-02-25 15:35:53 |
Message-ID: | CADZ4tWOnt0Rz=tqxyrGs=vf8yERLmnK=b06_QkE_-F9Oowz6Mg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)com>
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Lewis | 2021-02-25 15:37:52 | Re: Server hangs on pg_repack |
Previous Message | Jayadevan M | 2021-02-25 15:31:21 | Re: Postgres Analog of Oracle APPEND hint |