Re: [PERFORM] Select in FOR LOOP Performance

2005-03-04 Thread Tom Lane
Charles Joseph <[EMAIL PROTECTED]> writes: > I face problem when running the following pgplsql > function. The problem is it takes more than 24hours to > complete > the calculation. The EMP table has about 200,000 > records. Sure there are no infinite loops of PARENT links in your table?

[PERFORM] Select in FOR LOOP Performance

2005-03-04 Thread Charles Joseph
I face problem when running the following pgplsql function. The problem is it takes more than 24hours to complete the calculation. The EMP table has about 200,000 records. I execute the function through psql "select calculate()"; (There is no cyclic link inside the data). Comp