PostgreSQL Out of Memory

Поиск
Список
Период
Сортировка
От liam saffioti
Тема PostgreSQL Out of Memory
Дата
Msg-id CAGHjuaYK33cGgHYUm1ObnxPJ2a8TSnSwcVDXGb4Fk1qfP12gGA@mail.gmail.com
обсуждение исходный текст
Ответы Re: PostgreSQL Out of Memory  (Mladen Gogala <gogala.mladen@gmail.com>)
Re: PostgreSQL Out of Memory  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-admin
Hi Teams,

I have PG 14.5 on RHEL 8.4. I see many errors. Do you have any idea about this problem?

TopMemoryContext: 1194808 total in 12 blocks; 3968 free (3 chunks); 1190840 used
  TopTransactionContext: 592728 total in 9 blocks; 30328 free (4 chunks); 562400 used
    ExecutorState: 551680 total in 8 blocks; 147192 free (31 chunks); 404488 used
      BTree array context: 4096 total in 3 blocks; 3488 free (9 chunks); 608 used
      TupleSort main: 3153976 total in 2 blocks; 6728 free (7 chunks); 3147248 used
        TupleSort sort: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
          Caller tuples: 16777216 total in 12 blocks; 624 free (13 chunks); 16776592 used
      ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
      ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
      MemoizeHashTable: 8192 total in 1 blocks; 7320 free (0 chunks); 872 used
      ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
      ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used
....

FATAL:  terminating background worker "parallel worker" due to administrator command
FATAL:  terminating background worker "parallel worker" due to administrator command
FATAL:  terminating background worker "parallel worker" due to administrator command
FATAL:  out of memory
FATAL:  out of memory
...

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: Understanding updates and deadlocks more clearly
Следующее
От: Mladen Gogala
Дата:
Сообщение: Re: PostgreSQL Out of Memory