Home > mailing lists

Re: Postgresql OOM - Mailing list pgsql-hackers

From	Radu Radutiu
Subject	Re: Postgresql OOM
Date	June 10 16:13:06
Msg-id	CAG4TxrgQ5V00eYTaRhPUbfp8Gnhzr4i2YooMGOhXW8U6RMmzNA@mail.gmail.com Whole thread Raw
In response to	Re: Postgresql OOM (Andres Freund <andres@anarazel.de>)
List	pgsql-hackers

Tree view

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 by date:

From: Andrew Dunstan
Date: 10 June, 15:58:49
Subject: Non-text mode for pg_dumpall

From: Robert Haas
Date: 10 June, 16:14:59
Subject: Re: Reuse child_relids in try_partitionwise_join was Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)

Re: Postgresql OOM - Mailing list pgsql-hackers

Previous

Next