I have a database dump that's about 140Gb. (When loaded, the database is about 350Gb.) I occasionally load copies of my dumped data into development and testing databases, which takes a while.
Any thoughts on what configurations I might be able to change during the restore in order to speed things along?
So far I have thought of:
Although I'm less sure about that checkpoint timeout value.
in my shell
And at some point I will try copying the dump file to the target system so that pg_restore can run on the same box, and ideally use the unix domain socket, rather than going over a TCP/IP network.
(9.6 on Ubuntu 17.04)