Re: Postgres Analog of Oracle APPEND hint

Unfortunately, I am not looking to load from an external source. My
process is moving data from source PostgreSQL tables to target PostgreSQL
tables.

On Thu, Feb 25, 2021 at 10:36 AM Mark Johnson <remi9898(at)gmail(dot)com> wrote:

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

--
Rumpi Gravenstein