agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] pljava causes postgres to consume excessive memory
2+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] pljava causes postgres to consume excessive memory
@ 2006-03-22 01:28  
  0 siblings, 1 reply; 2+ messages in thread

From:  @ 2006-03-22 01:28 UTC (permalink / raw)

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* [Pljava-dev] pljava causes postgres to consume excessive memory
@ 2006-03-22 06:26  
  parent: 
  0 siblings, 0 replies; 2+ messages in thread

From:  @ 2006-03-22 06:26 UTC (permalink / raw)

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
>
>   





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2006-03-22 06:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-22 01:28 [Pljava-dev] pljava causes postgres to consume excessive memory 
2006-03-22 06:26 ` 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox