Search Postgresql Archives

Re: Postgres Analog of Oracle APPEND hint

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

Subject: Re: Postgres Analog of Oracle APPEND hint
From: Merlin Moncure <mmoncure@xxxxxxxxx>
Date: Fri, 5 Mar 2021 14:15:53 -0600
Cc: Mark Johnson <remi9898@xxxxxxxxx>, PostgreSQL <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAEpg1wC3zHF8eA9qnA_zmteRc5zr3g3EP_FRZ5Me48yZhaGxrQ@mail.gmail.com>
References: <CAEpg1wD1xVNpT2LhraP+vCy=jwtFA4irTZgGXpuBBETLXkccvw@mail.gmail.com> <CADZ4tWOnt0Rz=tqxyrGs=vf8yERLmnK=b06_QkE_-F9Oowz6Mg@mail.gmail.com> <CAEpg1wC3zHF8eA9qnA_zmteRc5zr3g3EP_FRZ5Me48yZhaGxrQ@mail.gmail.com>

On Thu, Feb 25, 2021 at 10:26 AM Rumpi Gravenstein <rgravens@xxxxxxxxx> 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

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

References:
- Postgres Analog of Oracle APPEND hint
  - From: Rumpi Gravenstein
- Re: Postgres Analog of Oracle APPEND hint
  - From: Mark Johnson
- Re: Postgres Analog of Oracle APPEND hint
  - From: Rumpi Gravenstein

Prev by Date: Re: Log files polluted with permission denied error messages after every 10 seconds
Next by Date: Unkillable processes creating millions of tiny temp files
Previous by thread: Re: Postgres Analog of Oracle APPEND hint
Next by thread: PostgreSQL URI
Index(es):
- Date
- Thread

[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