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

Josef Machytka <josef.machytka@gmail.com>

From: Josef Machytka <josef.machytka@gmail.com>

To: Jeff Janes <jeff.janes@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Fabrízio Mello <fabriziomello@gmail.com>, Pg Bugs <pgsql-bugs@postgresql.org>

Date: 2017-10-10T09:27:49Z

Lists: pgsql-bugs

"What could help is running 'analyze' locally against the foreign table.
That can cause other problems, though."

Yes, this really helped - ANALYZE on foreign table took ~45 minutes but
after that I was able to get results and memory was OK too. Only several
hundreds of MB used...