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

From: Josef Machytka <josef(dot)machytka(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Fabrízio Mello <fabriziomello(at)gmail(dot)com>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance
Date: 2017-10-10 09:27:49
Message-ID: CAGvVEFuPVE8nZB7hJLkGm-=1kuhz5VCFBB_HoC=kEjFw9VjqPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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...

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Aleksander Alekseev 2017-10-10 10:26:13 Re: [BUGS] 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger
Previous Message rainersharp 2017-10-10 08:44:13 BUG #14848: simple Query script not work