Hi,
I am trying to import a database of size 300+gb to another server. It's taking a long time.
4vCPU
15GB RAM
psql -h newserver -U dbuser -d production -W < prod.sql
Is there a way to speed up the importing process by tweaking Postgresql config like maintenance_workmem, work_mem, shared_buffers etc.,