Re: Out of Memory errors are frustrating as heck!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Out of Memory errors are frustrating as heck!
Дата
Msg-id 26356.1566570031@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Out of Memory errors are frustrating as heck!  (Gunther <raj@gusw.net>)
Ответы Re: Out of Memory errors are frustrating as heck!  (Gunther <raj@gusw.net>)
Список pgsql-performance
Gunther <raj@gusw.net> writes:
> Hi all, I am connecting to a discussion back from April this year. My 
> data has grown and now I am running into new out of memory situations. 

It doesn't look like this has much of anything to do with the hash-table
discussion.  The big hog is an ExprContext:

> ExprContext: 1107296256 total in 142 blocks; 6328 free (101 chunks); 
> 1107289928 used

So there's something leaking in there, but this isn't enough info
to guess what.

            regards, tom lane



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

Предыдущее
От: Gunther
Дата:
Сообщение: Re: Out of Memory errors are frustrating as heck!
Следующее
От: andy andy
Дата:
Сообщение: pg_basebackup is taking an unusually long time with Postgres 11.3