Yes, it is running. On shared database plans (koi and blossom) it can take a few days or longer to get around to analyzing your database.
Oren On Thu, Oct 21, 2010 at 6:18 AM, Kevin Patel <[email protected]> wrote: > I'm also very interested in finding out if auto-vacuum/analyze is > configured and running. As not running analyze on large table can > throw off the query planner quite a bit. > > \Kevin > > On Oct 20, 11:55 am, Mike <[email protected]> wrote: > > I was having some puzzling behavior from my Heroku application. A page > > with a simple query that joined two tables (one small, one enormous) > > was taking minutes to return and bringing down my whole app with > > timeouts. > > > > I downloaded the bundle and installed it into my development machine, > > and the same page with that query loaded flawlessly. > > > > After poking around some more, I narrowed the problem down to the > > database. We don't have direct database access, so I loaded up the > > Heroku console and called on my table: > > ActiveRecord::Base.connection.execute "analyze X" > > > > After that the same pages and queries return instantaneously, and the > > problem was resolved. I had originally tried calling vacuum analyze, > > but that takes too long for the Heroku command line and timed out. > > > > It seems strange to me that I would have to do this myself given we > > don't even have database access, but this problem persisted for two > > days between when I first observed it and when I finally resolved it. > > > > Does Heroku have auto-vacuum/analyze configured and running on our > > Postgres databases? When should we be running analyze ourselves? > > -- > 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.
