On Thu, Feb 25, 2021 at 10: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.
INSERT INTO ...SELECT ... is one of the fastest ways possible to move
data aroun
On 2021-02-25 14:52:20 -0500, Rumpi Gravenstein wrote:
> My use case involves complicated joins on source tables in one schema loading
> a
> target table in the same or a different schema.
So source(s) and target are in the same database? That wasn't clear from
your earlier mails.
If you are doi
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 wrote:
> On 2/25/21 9:26 AM, Rumpi Gravenstein wrote:
> > Unfortunately, I am not looking to load from an external source.
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
Rumpi Gravenstein writes:
> Unfortunately, I am not looking to load from an external source. My
> process is moving data from source PostgreSQL tables to target PostgreSQL
> tables.
The hints in
https://www.postgresql.org/docs/current/populate.html
would still largely apply, though of course n
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 wrote:
> Since INSERT /*+APPEND*/ is generally used when bulk loading data into
> Oracle from exter
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
>
> 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 Postgre
