Re: Postgresql 7.4.3/8.2.4 out of memory

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Postgresql 7.4.3/8.2.4 out of memory
Дата
Msg-id 20070606085138.GB8997@svana.org
обсуждение исходный текст
Ответ на Postgresql 7.4.3/8.2.4 out of memory  (Christophe Combet PBIL/IBCP/CNRS <c.combet@ibcp.fr>)
Список pgsql-general
On Wed, Jun 06, 2007 at 10:57:25AM +0200, Christophe Combet PBIL/IBCP/CNRS wrote:
> Dear all,
>
>
> With the below transaction we got an out of memory error.

<snip>

Here's your problem:

> AfterTriggerEvents: 3170885632 total in 397 blocks; 12200 free (384
> chunks); 3170873432 used

You've got some kind of deferred constraint/trigger and it's running
out of memory trying to remember what it has deferred. The two ways I
know to deal with this are:
1. Make the constraint immediate, somehow
2. Temporarily disable the constraint.

Maybe someone else has an idea?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Christophe Combet PBIL/IBCP/CNRS
Дата:
Сообщение: Postgresql 7.4.3/8.2.4 out of memory
Следующее
От: Franz.Rasper@izb.de
Дата:
Сообщение: Re: Corruption of files in PostgreSQL