Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-jdbcpgsql-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

pgsql-admin by date

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

pgsql-patches by date

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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group