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 491f66a50906230513q50576e3ha3ddfa4a2480328@mail.gmail.com
Whole thread Raw
In response to Re: Queries very slow and memory consumption too high  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-jdbc


On Tue, Jun 23, 2009 at 6:30 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Dave Cramer wrote:
> This also suggests that you have not tuned pg. 35M shared
> memory is not very much. You should look at tuning the installation.

Maybe, but first the problem should be identified, else this falls into
the category of "changing things without knowing why".
Maybe the whole database is only 30MB big?

Certainly a valid point, however the fact that it is untuned suggests that the OP should read about tuning.

DAve


Yours,
Laurenz Albe

pgsql-jdbc by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Queries very slow and memory consumption too high
Next
From: Jesper Pedersen
Date:
Subject: [Patch] Binary Transfer v13