We've been doing some hefty performance testing of the Heroku Postgres dbs with the help of some of the people on the data team (thank you guys!) and we just wanted to share some rough performance numbers that hopefully might help you when you're selecting a db type next time.
Setup: We have some large ETL operations that obviously are very write heavy and we wanted to get an idea which db tier was best in terms price/performance. We're using the COPY command to move 2 million rows of data from one db (a zilla) to another and we wanted to get an idea of what the performance differences were between the tiers. The Zilla that is being copied from doesn't change between tests and for each new test we spin up a new db to make sure we are testing from a clean slate. DB Type - Time to copy in minutes Ronin - 35:04 Fugu - 26:43 Ika - 8:34 Zilla - 7:22 We didn't test a mecha (yet) or anything below Ronin because the COPY literally wouldn't complete on anything lower than that. One thing we did realize with the help of the Heroku PG team is that there is some serious variance in performance on newly provisioned dbs. They are currently hypothesizing that it is related to the nature of the dynamic disk space provisioning that happens as large amounts of data are inserted into a freshly provisioned db. We saw in many instances close to 50% slower speeds. Sometimes it would run normally (those are the values we listed above) but for example on the Ika runs, we would sometimes see it take close to ~15 minutes to complete the copy. After some initial hiccups though we believe all dbs move towards there normal performance numbers listed above so just keep that in mind when you are provisioning a new db. Anyways, hope this was helpful and we would love to hear from anyone else doing performance testing on the PG dbs. -- -- You received this message because you are subscribed to the Google Groups "Heroku" group. 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_US?hl=en --- You received this message because you are subscribed to the Google Groups "Heroku Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
