Re: ERROR: Out of memory - when connecting to database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: Out of memory - when connecting to database
Дата
Msg-id 29618.1289248318@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ERROR: Out of memory - when connecting to database  (Jakub Ouhrabka <kuba@comgate.cz>)
Ответы Re: ERROR: Out of memory - when connecting to database  (Jakub Ouhrabka <kuba@comgate.cz>)
Список pgsql-general
Jakub Ouhrabka <kuba@comgate.cz> writes:
> Could it be that the failed connections were issued by autovacuum?

They clearly were: notice the reference to "Autovacuum context" in the
memory map.  I think you are right to suspect that auto-analyze was
getting blown out by the wide bytea columns.  Did you have any
expression indexes involving those columns?

            regards, tom lane

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

Предыдущее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: finding the other statement causing a sharelock
Следующее
От: Jakub Ouhrabka
Дата:
Сообщение: Re: ERROR: Out of memory - when connecting to database