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

[PERFORM] Parallel Function calls using multiple processes

2009-12-15 Thread 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 rather than parallel, which mea

Re: [PERFORM] big select is resulting in a large amount of disk writing by kjournald

2009-12-15 Thread Scott Carey
On 12/10/09 8:41 AM, "Kevin Grittner" wrote: > > There has been some talk about possibly writing tuples in a frozen > state with the hint bits already set if they are loaded in the same > database transaction which creates the table, but I'm not aware of > anyone currently working on this. >