Re: Queries very slow and memory consumption too high - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Queries very slow and memory consumption too high
Date
Msg-id 491f66a50906230313ja128291k1363095bcef6ae18@mail.gmail.com
Whole thread Raw
In response to Re: Queries very slow and memory consumption too high  (Saurabh Dave <saurabhdave@gmail.com>)
Responses Re: Queries very slow and memory consumption too high
List pgsql-jdbc


On Tue, Jun 23, 2009 at 4:44 AM, Saurabh Dave <saurabhdave@gmail.com> wrote:
>>If your problem is something that develops over time, one thing
>>you could watch out for are resource leaks, most prominently
>>memory leaks.

What is the recommended way to do that? It seems postgres uses shared memory, and we have 15 connections all taking up around 35MB as per task manager OR top. We are not able to figure out definitatively if there is a memory leak.
Help/Clues??? Thanks all for your responses so far.

This also suggests that you have not tuned pg. 35M shared memory is not very much. You should look at tuning the installation.

Dave

- Saurabh



On Tue, Jun 23, 2009 at 1:35 PM, Craig Ringer <craig@postnewspapers.com.au> wrote:
On Tue, 2009-06-23 at 09:38 +0200, Albe Laurenz wrote:

> Moving to 8.3.7 (what is 8.3.7.1?), on the other hand, is certainly
> a good thing.

Probably a Linux distro packaging thing, or a Windows installer
revision. On my Ubuntu 9.04 box for example, `dpkg -l postgresql-8.3'
reports Pg's version as 8.3.7-1 . The -1 is the Debian package revision,
but people may not know that.

--
Craig Ringer



pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Queries very slow and memory consumption too high
Next
From: "Albe Laurenz"
Date:
Subject: Re: Queries very slow and memory consumption too high