How can I avoid that
От | ohp@pyrenet.fr |
---|---|
Тема | How can I avoid that |
Дата | |
Msg-id | Pine.UW2.4.53.0311241800370.17199@server.pyrenet.fr обсуждение исходный текст |
Список | pgsql-hackers |
Hi all, I know you're all busy with 7.4 comming out and I was wondering if some one could have an idea about the following: I host a game that does a HEAVY use of postgresql working like a charm. But when the server is a little busy (like when Marc approves a WAG of mail), postgresql dosn't respond so fast and users start clicking on the reload button, making a new connection, re-issuing the query and so forth. Now those "slow" query seem to last forever (several minutes CPU). My guts feel thatpostgresql doesn't have a clue that the connection with web server is broken and just continue to run. Can I avoid that? Regards -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)
В списке pgsql-hackers по дате отправления: