Several queries consume 100 % processor

Поиск
Список
Период
Сортировка
От J. ORIOL
Тема Several queries consume 100 % processor
Дата
Msg-id 478216.94761.qm@web34709.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: Several queries consume 100 % processor  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Several queries consume 100 % processor  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Hi,

I have an app working over LAN , XP + Postgres 8.2. The problem is that a client send several queries and the processor show me 100 % usage. (P IV 3 Ghz with 1 Gb RAM) and stops all its tasks until queries finishes.

This queries are send from inside app code, should I create procedures for every one of the queries inside Postgres ?, How much response time will be improved with this ?

Any help will be useful for me, thanks.


----------------------
J. Oriol Mujica F.
----------------------
Bucaramanga - COLOMBIA

__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.espanol.yahoo.com/

В списке pgsql-general по дате отправления:

Предыдущее
От: "btober"
Дата:
Сообщение: Re: Integrity on large sites
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Several queries consume 100 % processor