Dear All Experts,
We have a java exe making a call to a postgres function. This postgres function internally makes a call to a dll (which is written using Postgres extended C). Now the issue is that, when we make a call to this dll, it consumes a lot of memory and this memory is getting consumed from the heap space of the original java process causing an out of memory exception in Java. Is this a known issue. Do we have a way to keep these processes disjoint and not eat up heap space of the original process? Please provide your suggestions/advises on the same. Sorry missed few information. I am using PostgreSQL 8.3.5 on Windows XP with 4GB of RAM and 160GB of hard drive with Core 2 Duo processor CPU @ 6300 1.86 GHz.
