ONE MORE PERFORMANCE ISSUE WITH POSTGRES

From: Savita <savita(at)india(dot)hp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ONE MORE PERFORMANCE ISSUE WITH POSTGRES
Date: 2002-10-29 11:12:04
Message-ID: 3DBE6D04.D81F31C0@india.hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I just wanted to know is it possible to improve the performance of a query if
the query is calling any stored procedure in it.

Because when I run this query it takes 100% CPU usage and other applications are
hanging.

Please let me nkow the solution is there something we can apply in stored
procedure.

--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florian Litot 2002-10-29 12:58:29 error in insertion
Previous Message ghinchliffe 2002-10-29 10:44:08 DAFS?