[Pljava-dev] pljava causes postgres to consume excessive memory

[Thomas Hallgren]

Hi Sriram,
I'm just fixed bug

http://gborg.postgresql.org/project/pljava/bugs/bugupdate.php?1542. From the sound of it, you are affected by it. What platform are you on? Are you able to compile from source?

Kind Regards,
Thomas Hallgren


Sriram Dandapani wrote:
> Hi Thomas
>
> When using pljava to issue jdbc commands, the memory consumed by
> postgres is a lot more than when not using jdbc. 
>
> We use pljava with a jdbc connection to simulate autonomous transactions
> of the kind that Oracle provides.
>
> One of our application requirements is the insert of a large chunk of
> data (this scenario happens occasionally but it is something we need to
> take into account). When say inserting 4 million rows in a table with a
> jdbc command that does a "insert into select * from"
> The top command shows the insert command as a separate process that
> consumes most of the memory and also a postmaster writer process that
> also consumes a lot of memory
>
> Whe  I run the same insert from pgadmin, the memory usage seems to be
> managed well by just the postmaster process and there is no separate
> writer process that consumes memory.
>
> Why does postgres/pljava behave this way.
>
> Regards
>
> Sriram
>
>