Long running queries?
Q. I have some queries which run for quite a while, presumably as they involve large joins. Does the server continue to run them after the web session times out, eventually creating the results file in the directory? Could one simply keep checking for a new results file and download it once the query has completed? At the moment I’ve had to write an agent to fill out the form and divide the query up but it is painfully slow and undoubtedly a larger load on your server … –JamesHowison (3 Jan 2008) A. It is hard to tell exactly what happens to a query when the session times out. Most long running queries are computationally infeasible and will cause the SQL thread to run out of memory in which case the thread will need to be killed. Presumably, if a query will not cause the PostgreSQL thread to run out of memory, it should finish even after the session times out. The session timeout has been raised to 30 minutes, so this should ameliorate the problem. Additionally, web services should
