Re: [GENERAL] Re: Monitoring activities of PostgreSQL ("Everlasting" function execution)

2010-06-17 Thread Allan Kamau
On Wed, Jun 16, 2010 at 1:15 PM, Craig Ringer wrote: > On 16/06/10 16:56, Allan Kamau wrote: > >> The function I have mentioned above seems to "hang" indefinitely (now >> 12hours and counting) while it took only 2secs for the many times it >> was previously invoked from the client application (wit

Re: [GENERAL] Re: Monitoring activities of PostgreSQL ("Everlasting" function execution)

2010-06-17 Thread Allan Kamau
On Wed, Jun 16, 2010 at 1:15 PM, Craig Ringer wrote: > On 16/06/10 16:56, Allan Kamau wrote: > >> The function I have mentioned above seems to "hang" indefinitely (now >> 12hours and counting) while it took only 2secs for the many times it >> was previously invoked from the client application (wit

Re: [GENERAL] Re: Monitoring activities of PostgreSQL ("Everlasting" function execution)

2010-06-16 Thread Craig Ringer
On 16/06/10 16:56, Allan Kamau wrote: > The function I have mentioned above seems to "hang" indefinitely (now > 12hours and counting) while it took only 2secs for the many times it > was previously invoked from the client application (with slightly > different parameter value at each such time).

[GENERAL] Re: Monitoring activities of PostgreSQL ("Everlasting" function execution)

2010-06-16 Thread Allan Kamau
On Tue, Jun 15, 2010 at 5:03 PM, Allan Kamau wrote: > I do have a PL/SQL function that gets executed called many times but > with different parameter values each of these times. For most > invocations of this function run in a couple of seconds however some > invocations of the same function run (