Postgres Pro
Downloads
Home   >   mailing lists

ONE MORE PERFORMANCE ISSUE WITH POSTGRES - Mailing list pgsql-general

From Savita
Subject ONE MORE PERFORMANCE ISSUE WITH POSTGRES
Date
Msg-id 3DBE6D04.D81F31C0@india.hp.com
Whole thread Raw
In response to Formatting query output  (Pedro Miguel Frazao Fernandes Ferreira <pfrazao@ualg.pt>)
Responses error in insertion  (Florian Litot <flitot@besancon.sema.slb.com>)
Re: ONE MORE PERFORMANCE ISSUE WITH POSTGRES  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Tree view 
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)
----------------------------------------------------

pgsql-general by date:

Previous
From: ghinchliffe@vianetworks.co.uk
Date:
Subject: DAFS?
Next
From: Andrew Sullivan
Date:
Subject: Re: Automatic insertion on insertion on another table