I have a situation where there are dozens of daemons hitting the same postgres database. They all run different types of queries but each daemon runs the same set of queries over and over again. Sometimes some queries get "stuck" in that they run for hours and hours. They never stop running. Killing the deamon does not stop the query from running. Once there are three of four of these "stuck" queries the database slows down drastically. Is there a way to tell postgres to stop any query that runs longer than a specified amount of time? Say an hour? Failing that what is a good strategy for detecting stuck queries and killing them. Thanks. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
