From: | sdandapani at counterpane(dot)com (Sriram Dandapani) |
---|---|
To: | |
Subject: | [Pljava-dev] pljava causes postgres to consume excessive memory |
Date: | 2006-03-22 01:28:12 |
Message-ID: | 6992E470F12A444BB787B5C937B9D4DF03C48C2A@ca-mail1.cis.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2006-03-22 06:26:13 | [Pljava-dev] pljava causes postgres to consume excessive memory |
Previous Message | Thomas Hallgren | 2006-03-21 18:37:24 | [Pljava-dev] pljava reninitializing jdbc connection pool for every invocation |