Re: "out of memory" error

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: "out of memory" error
Дата
Msg-id Pine.BSO.4.56.0405021745100.3919@leary.csoft.net
обсуждение исходный текст
Ответ на "out of memory" error  (Rachel McConnell <rachel@enginegreen.com>)
Список 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 по дате отправления:

Предыдущее
От: Keary Suska
Дата:
Сообщение: Re: Vacuumdb Errors --Any ideas?
Следующее
От: Alexander Cohen
Дата:
Сообщение: Re: pgsql folder and its contents