Am 05.05.19 um 19:26 schrieb Ron:
On 5/5/19 12:20 PM, Andreas Kretschmer wrote:Am 05.05.19 um 18:47 schrieb Sathish Kumar:Is there a way to speed up the importing process by tweaking Postgresql config like maintenance_workmem, work_mem, shared_buffers etc.,sure, take the dump in custom-format and use pg_restore with -j <number_of_jobs>.Custom format or directory format?
both are possible for that. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com
