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) without locking destination table.
Pg_bulkload is the fastest way but it locks the table.
Are there other ways?
Classic "COPY" from?
Thank you!
F