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

Collapse
2: Re: Postgres deadlock & maximum execution time (response to 1)
Posted by Dave Bauer on 11/09/06 08:11 PM
You should find and fix those queries that are long running.

You can cancel a long running query without stopping AOLserver or PostgreSQL.

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

Collapse
3: Re: Postgres deadlock & maximum execution time (response to 2)
Posted by Marc Kalberer on 11/12/06 11:05 AM
My problem is a bit different.
I had to setup an advanced search engine with a lot of criteria. Depending on which categories/options are choose 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 ?