If you're using a dedicated database (and if your queries are non-trivial you probably want to move off the shared ones) then you can just use heroku pg:ingress + psql.
-p On Wed, Dec 8, 2010 at 10:51 AM, Zach Bailey <[email protected]> wrote: > I'm wondering if anyone has had experience importing a large amount of > data into their heroku database and how they went about doing it. I'm > staring down about 3-4M rows of (static) data that I'd like to get into our > DB on Heroku. > > > If I had my own database locally I would probably use the COPY command as > it is blazing fast. Inserting a row at a time from ruby code or going > through an exposed API is looking like it will take multiple days to do > (without spending extra money to crank up more dynos and buy a larger DB > option) > > > Another option I thought of would be to figure out a way to load the data > in a local db then dump only that table and restore it into the heroku db as > a partial backup, but I didn't see any facility for that. > > > Has anyone done anything like this or think of a good way for doing it? > > > Thanks, > Zach > > -- > You received this message because you are subscribed to the Google Groups > "Heroku" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<heroku%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en. > -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
