maksim_karaba(at)epam(dot)com writes:
> We are getting error "server process was terminated by signal 11:
> Segmentation fault" and server goes to recovery mode on production system.
> It repeats several times a day, always on complicated updates using
> postgres_fdw.
Please show the failing query or queries. (If you don't have postmaster
logs showing them, "p debug_query_string" in the core files should get
the info.) Also, please show EXPLAIN VERBOSE plans for the query(s),
as well as schema information (psql \d output would do) for the
referenced tables.
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
regards, tom lane