Is there a way to speed up restoring data from MySQL to PostgreSQL?
You should try pgloader : http://pgloader.io/howto/mysql.html It can load data from MySQL to PostgreSQL using COPY mode, which is faster than INSERT.