Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance - Mailing list pgsql-bugs

From Josef Machytka
Subject Re: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance
Date
Msg-id CAGvVEFuPVE8nZB7hJLkGm-=1kuhz5VCFBB_HoC=kEjFw9VjqPw@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-bugs
Tree view


"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...

pgsql-bugs by date:

Previous
From: rainersharp@gmail.com
Date:
Subject: [BUGS] BUG #14848: simple Query script not work
Next
From: Aleksander Alekseev
Date:
Subject: Re: [BUGS] 10.0: Logical replication doesn't execute BEFORE UPDATEOF trigger