Re: Big insert/delete memory problems

Tom,

After installing the compiled version, things are looking better. The
processes are still growing, but not nearly as fast as before

I think this problem may have something to do with my connection from
Tomcat. I'm using the JDBC2 drivers from postgresql.org, and when I
reset my tomcat, memory usage on those backends goes way down (back to
normal). So it seems like something in the JDBC driver is keeping those
backends large. I'm using the PooledDataSource object for accessing
this database. Don't know if that helps or not. I'll try to post to
the JDBC list and see what I can find. Thanks again!

/kurt

Tom Lane wrote:
> Kurt Overberg <kurt(at)hotdogrecords(dot)com> writes:
>
>>main question:
>
>
>>During a large select/insert like this, the memory use of the pgsql
>>backend goes up, right?
>
>
> No, it's not supposed to go up in the first place. When I run what
> I think is the same case, I don't see the backend's resident-set-size
> going above a couple meg. You seem to be suffering an internal memory
> leak, which is not a very surprising kind of bug --- but I don't
> understand why I can't duplicate it.
>
> Let's see ... what locale and encoding are you using? Maybe it depends
> on that.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>