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>. You can increase maintenance_work_mem maybe to 4GB to speedup index creation.
Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com
