Re: BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance

Feike Steenbergen <feikesteenbergen@gmail.com>

From: Feike Steenbergen <feikesteenbergen@gmail.com>
To: josef.machytka@gmail.com
Cc: PostgreSQL mailing lists <pgsql-bugs@postgresql.org>
Date: 2017-10-06T13:04:33Z
Lists: pgsql-bugs
On 6 October 2017 at 13:24, <josef.machytka@gmail.com> wrote:
> After that in first case postgresql crashed (which was more or less OK
> because it restarted) but in second case the whole Debian instance crashed

What causes the crash, is it the out-of-memory (OOM) killer?
How have you configured overcommit on your Debian instance?

https://www.postgresql.org/docs/current/static/kernel-resources.html#linux-memory-overcommit

If it is the OOM killer killing your process, you may want to disable
overcommit. Doing that should cause the client to get a decent error
message instead of the the whole cluster being restarted.

regards,

Feike