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.,
