Why is this code slower?

Just updating my code to be Rails 3 ready, however I'm experiencing a major performance issue with the code below.

Old code (nice and quick)

@products = Product.all(
                        :order => 'name',
                        :include => [:category, :brand, :merchant]
                       ).paginate(:page => params[:page])

New code (10 x slower)

@products = Product.order("name")
                   .includes([:cat开发者_运维知识库egory, :brand, :merchant])
                   .paginate(:page => params[:page])

I added the line breaks for easy reading.

I'm using Postgres for my DB, maybe this is the issue?

Any other tips to make this code better will be much appreciated!

---

I'd check the outputted SQL (from logs or the console) to see if something's changed and/or how the query might be optimized.

---

Can it be a problem with the pagination? Which plugin are you using for pagination? You might want to try Kaminari.