Re: Re: [ADMIN] High memory usage [PATCH]

From: Gunnar Rønning <gunnar(at)polygnosis(dot)com>
To: "Dave Cramer" <Dave(at)micro-automation(dot)net>
Cc: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Rainer Mager" <rmager(at)vgkk(dot)com>, "PostgreSQL jdbc list" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Re: [ADMIN] High memory usage [PATCH]
Date: 2001-06-22 11:42:12
Message-ID: m2bsngrbaj.fsf@smaug.polygnosis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc pgsql-patches

* "Dave Cramer" <Dave(at)micro-automation(dot)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(at)polygnosis(dot)com
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dave Cramer 2001-06-22 13:19:05 RE: Re: [ADMIN] High memory usage [PATCH]
Previous Message Kostis Mentzelos 2001-06-22 08:35:41 Re: rename a table

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2001-06-22 13:19:05 RE: Re: [ADMIN] High memory usage [PATCH]
Previous Message Rainer Mager 2001-06-22 04:56:17 RE: Re: [ADMIN] High memory usage [PATCH]

Browse pgsql-patches by date

  From Date Subject
Next Message Karel Zak 2001-06-22 12:01:27 Re: nocreatetable for 7.1.2 [patch]
Previous Message RISKO Gergely 2001-06-22 11:13:50 Re: nocreatetable for 7.1.2 [patch]