Re: Re: [ADMIN] High memory usage [PATCH] - Mailing list pgsql-jdbc

From Gunnar Rønning
Subject Re: Re: [ADMIN] High memory usage [PATCH]
Date
Msg-id m2bsngrbaj.fsf@smaug.polygnosis.com
Whole thread Raw
In response to Re: Re: [ADMIN] High memory usage [PATCH]  ("Dave Cramer" <Dave@micro-automation.net>)
Responses RE: Re: [ADMIN] High memory usage [PATCH]  ("Dave Cramer" <davec@sentricity.com>)
List pgsql-jdbc
* "Dave Cramer" <Dave@micro-automation.net> wrote:
|
| my two cents worth...
|
| 1) what is the problem that this is trying to solve, I assume from the
| subject that it is some sort of high memory usage?

I would like to know as well.

| 2) I am trying to understand how a statement would ever be used by more than
| one thread at a time? I would think that it would be impossible to share
| statements across threads.

Quite easy. Just the same way as you share any other object across threads
and according to the JDBC spec requires that the driver shoudl be thread
safe.


| 3) The double locking method used is alledgedly unsafe on SMP machines
| http://www.javaworld.com/javaworld/jw-02-2001/jw-0209-double_p.html.

Yup, double checked locking is not going to guarantee that you get
properly initialized objects with the current Java spec.

--
Gunnar Rønning - gunnar@polygnosis.com
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/

pgsql-jdbc by date:

Previous
From: "Dave Cramer"
Date:
Subject: Re: Re: [ADMIN] High memory usage [PATCH]
Next
From: "Dave Cramer"
Date:
Subject: Re: The bytea datatype and JDBC