Hi Sorens, sorry I didn't get back to you earlier. PostgreSQL only checks for connection interruption between statements -- this is an unfortunate design decision and perhaps something that could be better emphasized with the project as a serious production problem. (In fact, I may go start a thread on this issue right now!)
When this occurs, you could use pg_cancel_backend(<query pid>) IF you were a superuser. Unfortunately, in order to provide a stable service we can't give that out. Because of that, we've worked with the project to upstream a fix, which should arrive with 9.2, and we're currently looking at backporting that patch to all new databases as soon as it stabilizes. Other than that, I'm afraid there's not much you can do currently except try not to issue single statements which cause big problems. Really sorry I don't have better news to bring you. It's an issue we're obviously tracking closely and working on a solution for but there isn't one available yet. Best, Peter Heroku Postgres On Fri, Dec 16, 2011 at 10:12 AM, sorens <[email protected]> wrote: > Our web app is running on heroku with a dedicated postgres DB. We have > a long query that we're fixing(separate issue), but we noticed that > the rack-timeout did not cut the request off at 15 seconds as > expected. I posted a question about it on StackOverflow. > > > http://stackoverflow.com/questions/8512540/a-slow-postgres-query-on-heroku-is-not-being-interrupted-by-rack-timeout > > Does anyone have insight into how I can make rack-timeout cut off this > request? While we're tracking down the query issue, having the query > take out the service is causing problems. > > Thanks, > Steve > > -- > 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. > > -- 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.
