[Pljava-dev] out of memory

Thomas Hallgren napisa?(a):
> I don't know why it hangs. An out-of-memory would typically cause a
> termination, not a hanging. Which JVM are you using and on which
> platform? What is the behavior of your hung process? Is it consuming
> lots of CPU cycles or none at all?

This "top" was taken after start:
-------------
top - 07:46:50 up 73 days, 14:31, 1 user, load average: 1.39, 0.67, 0.24
Tasks: 98 total, 5 running, 93 sleeping, 0 stopped, 0 zombie
Cpu(s): 47.3% user, 5.7% system, 0.0% nice, 47.0% idle
Mem: 904848k total, 898940k used, 5908k free, 608k buffers
Swap: 2048276k total, 348036k used, 1700240k free, 29460k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
29590 postgres 17 0 1133m 806m 18m R 95.0 91.2 2:58.75 postmaster
------------

After couple of minutes pljava stops (but no error is returned) and
postgresl process is still working:
------------
top - 07:55:38 up 73 days, 14:40, 1 user, load average: 1.23, 1.42, 0.83
Tasks: 105 total, 1 running, 104 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.5% user, 4.4% system, 0.0% nice, 95.2% idle
Mem: 904848k total, 898668k used, 6180k free, 1068k buffers
Swap: 2048276k total, 1794380k used, 253896k free, 50136k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
29590 postgres 10 0 2472m 752m 34m D 0.6 85.2 8:55.40 postmaster
------------

> Well, if you have a chance, please try out the new stuff. The fix
> regarding set returning functions is not the only change since 1.2 and
> I'd hate to spend time on something that's not an issue in the new code.
I did that - but it doesn't affect the behavior of my function.

> OK, to rephrase my question - Do you rely on that ResultSets are closed
> by the Statement close
Yes

>or do you close them too explicitly?
No... should I do it ?

ML