Re: mysql_fdw trouble

John R Pierce <pierce@xxxxxxxxxxxx> · Thu, 29 Oct 2015 12:01:38 -0700



    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