Forum OpenACS Q&A: Re: Postgres deadlock & maximum execution time

Collapse
Posted by Dave Bauer on
You should find and fix those queries that are long running.

You can cancel a long running query without stopping aolserver or postgresql.

See http://openacs.org/xowiki/en/postgresql-admin

Collapse
Posted by Marc Kalberer on
My problem is a bit different.
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 ?