Forum OpenACS Q&A: Re: Postgres deadlock & maximum execution time
You can cancel a long running query without stopping aolserver or postgresql.
I had to setup an advanced search engine with a lot of criteria. Depending on which categ/options are choosen the query can run for a very long time. I optimized/debug it but some cases remain. That's why I wanted to put a timeout on queries ?
Is it possible ?