Re: [PERFORM] Parallel Function calls using multiple processes

2009-12-16 Thread Pavel Stehule
> > > - Original Message - > From: "Pavel Stehule" > To: "Vishal Gupta" > Cc: pgsql-performance@postgresql.org > Sent: Wednesday, December 16, 2009 1:04:48 PM GMT +05:30 Chennai, Kolkata, > Mumbai, New Delhi > Subject: Re: [PERFORM] Parallel Functio

Re: [PERFORM] Parallel Function calls using multiple processes

2009-12-16 Thread Vishal Gupta
From: "Pavel Stehule" To: "Vishal Gupta" Cc: pgsql-performance@postgresql.org Sent: Wednesday, December 16, 2009 1:04:48 PM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi Subject: Re: [PERFORM] Parallel Function calls using multiple processes 2009/12/16 Vishal Gupta :

Re: [PERFORM] Parallel Function calls using multiple processes

2009-12-15 Thread Pavel Stehule
2009/12/16 Vishal Gupta : > Problem: Function call typically takes 2-3 millisecond but at times > exceeding 2-3 Minutes. > = > From the DB logs it seems when multiple processes are trying to execute the > function, > execution takes sequentially r