Re: mysql_fdw trouble

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