| From: | "J(dot) ORIOL" <famach(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Several queries consume 100 % processor |
| Date: | 2007-05-23 12:50:42 |
| Message-ID: | 478216.94761.qm@web34709.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-05-23 12:59:17 | Re: Several queries consume 100 % processor |
| Previous Message | PFC | 2007-05-23 12:45:49 | Re: Using a trigger with an object-relational manager |