Re: Insert large number of records

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Job <Job(at)colliniconsulting(dot)it>
Cc: Alban Hertroys <haramrae(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Insert large number of records
Date: 2017-09-20 15:14:07
Message-ID: CAKFQuwZoL2demun=5BHaf9-e3A1B3KjieTrsi0+uFS9p27tufA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday, September 19, 2017, Job <Job(at)colliniconsulting(dot)it> wrote:

> and would not care about table partitioning (COPY command fire
> partitioned-table triggers).

You might want to write a script that inserts directly into the partitions
and bypass routing altogether.

Insert into ... select from ... is your only option for table-to-table and
you are stuck with whatever locks the execution of the command needs to
take.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Klaus P. Pieper 2017-09-20 15:15:36 Re: VM-Ware Backup of VM safe?
Previous Message George Neuner 2017-09-20 15:02:03 Re: VM-Ware Backup of VM safe?