Edson Richter [edsonrichter(at)hotmail(dot)com] writes:
>I don't know much about PostgreSQL with plJava, but I can give a few
>tips about memory stability when using Java (see inline):
...
>In the past, one choice was using static classes whenever possible. This
>is not true (neither recommended) anymore, and in most of the cases
>having thousands of cicles creation-use-release makes GC more effective
>(and your VM more stable).
PL/Java requires that the methods being directly called from PostgreSQL are static.
while i don't disagree with the advice, PL/Java is limited in this respect.
richard