Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Insert large number of records - Mailing list pgsql-general

From Job
Subject [GENERAL] Insert large number of records
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08180ABD2128@W2008DC01.ColliniConsulting.lan
Whole thread Raw
Responses Re: [GENERAL] Insert large number of records  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
Tree view 
Hi guys,

we need to insert from a table to another (Postgresql 9.6.1) a large amount of data (about 10/20 millions of rows)
withoutlocking destination table. 
Pg_bulkload is the fastest way but it locks the table.

Are there other ways?
Classic "COPY" from?

Thank you!
F


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: "Yason TR"
Date:
Subject: [GENERAL] JDBC: logical replication and LSN feedback
Next
From: Achilleas Mantzios
Date:
Subject: Re: [GENERAL] JDBC: logical replication and LSN feedback