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