Re: Postgres Analog of Oracle APPEND hint

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Rumpi Gravenstein <rgravens(at)gmail(dot)com>
Cc: Mark Johnson <remi9898(at)gmail(dot)com>, PostgreSQL <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres Analog of Oracle APPEND hint
Date: 2021-03-05 20:15:53
Message-ID: CAHyXU0y1Lu4xjPB8v2B87nTKO37HdH5g-+JHAyzMk8PX0qWyPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 25, 2021 at 10:26 AM Rumpi Gravenstein <rgravens(at)gmail(dot)com> wrote:
>
> Unfortunately, I am not looking to load from an external source. My process is moving data from source PostgreSQL tables to target PostgreSQL tables.

INSERT INTO ...SELECT ... is one of the fastest ways possible to move
data around.

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Finzel 2021-03-05 21:34:37 Unkillable processes creating millions of tiny temp files
Previous Message Andrus 2021-03-05 17:36:37 Re: Log files polluted with permission denied error messages after every 10 seconds