On 10/29/2015 11:20 AM, Dane Foster wrote:
I think you are correct about mysql_fdw "... sending the trim()
checks for remote execution" because according to the docs:
"The latest version will push-down the foreign table where clause to
the foreign server. The where condition on the foreign table will be
executed on the foreign server hence there will be fewer rows to to
bring across to PostgreSQL. This is a performance feature."
the alternative would be to fetch the whole table across the FDW
interface, then run the where locally, for a large table where you're
only selecting a few rows, this would be very painful.
I guess using mysql_fdw is a no-go for my data migration needs.
or, rewrite that WHERE clause to be mysql compatible.
--
john r pierce, recycling bits in santa cruz
