Re: "out of memory" error - Mailing list pgsql-general

From Kris Jurka
Subject Re: "out of memory" error
Date
Msg-id Pine.BSO.4.56.0405021745100.3919@leary.csoft.net
Whole thread Raw
In response to "out of memory" error  (Rachel McConnell <rachel@enginegreen.com>)
List pgsql-general

On Fri, 30 Apr 2004, Rachel McConnell wrote:

> Hello,
>
> I have a Java web application using Hibernate to connect to a PostgreSQL
> backend.  I am seeing the below stack trace during processing of a set
> of data consisting of around 1000 objects; for a 200 object set I don't
> see the exception.
>
> I believe the salient point is the Out Of Memory bit - marked below by
> *****'s
> The fact that this exception occurs during a call to
> org.postgresql.util.PSQLException.parseServerError() seems disturbing too.
>

This is a server error message (which is why the stracktrace starts at
parseServerError, although perhaps it shouldn't).  This means the
postgresql server ran out of memory, but you haven't provided any
information as to why that is.  You should check the server error log for
more information.  The key thing to check would be the actual query being
run. Is it using a bad plan query plan?  What other activity is going on
at this time?  How much memory do you have?

Kris Jurka

pgsql-general by date:

Previous
From: Keary Suska
Date:
Subject: Re: Vacuumdb Errors --Any ideas?
Next
From: Alexander Cohen
Date:
Subject: Re: pgsql folder and its contents