#postgres

Using IN is convenient, but can easily slow down your queries. Here's how to get around it!
I just upgraded one of our sites on Heroku to Postgres 9.1. Here's how I did it.
Summary: Use pg_restore -j number-of-jobs to restore an "archive format" dump in parallel.