Search code examples
ruby-on-railspostgresqlherokutaps

Taps gem is slow

I'm currently importing from Heroku a postgree database to my machine using Taps.

The database is around 5MB and has around 20k objects.

It is taking like 15 minutes so far.

Any idea why is taking so long and is there any way to make this faster? I can't imagine to work this way when the database grow 1 million objects and I need to do some moving on a harry. 

messages:      100% |==========================================| Time: 00:11:07

(that was a table with only 14k objects )

Solution

  • Downloading a backup is likely to be a lot quicker, if you have the (free) pgbackups addon and you don't mind the extra step of restoring the dump.

    https://devcenter.heroku.com/articles/pgbackups