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 по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: CVS HEAD is broken
Следующее
От: Neil Conway
Дата:
Сообщение: Using -Wshadow