| From: | Rumpi Gravenstein <rgravens(at)gmail(dot)com> |
|---|---|
| To: | Rob Sargent <robjsargent(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Postgres Analog of Oracle APPEND hint |
| Date: | 2021-02-25 19:52:20 |
| Message-ID: | CAEpg1wBvS-b7F_Fx4_U1075Fvw-z7Ujycr5ZsXm+LxKFSmcgMg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
My use case involves complicated joins on source tables in one schema
loading a target table in the same or a different schema.
On Thu, Feb 25, 2021 at 11:41 AM Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
> On 2/25/21 9:26 AM, Rumpi Gravenstein 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.
> >
> Are you trying to duplicate the source tables in the target tables? If
> so, there are replication tools for this. If not, temporary tables in
> the target db (possible loaded with copy) and smallish batches of
> inserts from those to target might be an option.
>
>
>
>
--
Rumpi Gravenstein
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2021-02-25 20:48:51 | Re: Deleting takes days, should I add some index? |
| Previous Message | Francisco Olarte | 2021-02-25 19:00:47 | Re: getting tables list of other schema too |