Re: Excessive memory used for INSERT

Поиск
Список
Период
Сортировка
От Alessandro Ipe
Тема Re: Excessive memory used for INSERT
Дата
Msg-id 6002240.FouBPN158i@snow.oma.be
обсуждение исходный текст
Ответ на Re: Excessive memory used for INSERT  (Torsten Förtsch <torsten.foertsch@gmx.net>)
Список pgsql-performance

On Thursday 18 December 2014 08:51:47 Torsten Förtsch wrote:

> On 17/12/14 16:14, Alessandro Ipe wrote:

> > 2014-12-15 17:54:07 GMT LOG: server process (PID 21897) was terminated

> > by signal 9: Killed

>

> since it was killed by SIGKILL, maybe it's the kernel's OOM killer?

 

Indeed and this hopefully prevented postgresql to crash my whole system due to RAM exhaustion. But the problem remains : why an INSERT requires that huge amount of memory ?

 

 

Regards,

 

 

A.

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

Предыдущее
От: Alessandro Ipe
Дата:
Сообщение: Re: Excessive memory used for INSERT
Следующее
От: Alessandro Ipe
Дата:
Сообщение: Re: Excessive memory used for INSERT