Re: Postgresql OOM

Поиск
Список
Период
Сортировка
От Radu Radutiu
Тема Re: Postgresql OOM
Дата
Msg-id CAG4TxrgQ5V00eYTaRhPUbfp8Gnhzr4i2YooMGOhXW8U6RMmzNA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql OOM  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Дерево обсуждения

FWIW, it can be useful to configure the OS with strict memory overcommit. That
causes postgres to fail more gracefully, because the OOM killer won't be
invoked.

In the current setup the database is used as an embedded db, with the application sharing the same host as the database. Setting the memory overcommit affects the other application, but configuring LimitAS for the postgresql systemd service should work. 
Does this mean that the fact that this query uses more than 100x the configured work_mem is not considered a bug? Should I create a bug report?
 

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Non-text mode for pg_dumpall
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Reuse child_relids in try_partitionwise_join was Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)