On Wed, Jan 25, 2012 at 8:20 PM, Linus Pettersson < [email protected]> wrote:
> Thank you. I have added the generated SQL to the snipt in my first post. > > Regarding the EXPLAIN ANALYZE, can I somehow run that on Heroku? I'm using > their shared database so I don't have access to any psql console... > > I did run it on my local machine though. The thing is that it differs in > database version (Local is PostgreSQL 9.1.2 while Heroku still uses 8.3 or > something) and also in size. > On Debian/Ubuntu you typically have a choice of an 8.4 or a 9.1 ... Try $ apt-cache search postgresql-8.4 and then you could install that alongside 9.1. It will run on a different port (one on 5432 and one on 5433 IIRC, check $ netstat -atn). That said, I have no information that the optimization would be different for such a "simple" query. > Anyway, the EXPLAIN ANALYZE from my local machine can be found here: > http://snipt.net/Linuus/postgresql?key=e4728f444b24839e3f80adf3829bcba9 > > <speculative> Just out of curiosity ... what problem are you trying to solve ? Did you actually see any slow queries ? I don't see obvious problems with the query ... Not sure if this is the area that deserves your first attention wrt performance optimization ... there is this whole story about "premature optimization" (Google it to find many rants about it ...). </speculative> HTH, Peter -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en.
