1 Reply Latest reply on Jul 1, 2015 4:01 PM by Ramesh Reddy

    Teiid vs Foreign Data Wrappers in Postgres

    Andriy Rokhmanov Newbie

      Hi,

       

      Has anybody compared the Teiid and FDW functionality from Postgres?

      https://wiki.postgresql.org/wiki/Foreign_data_wrappers

      Especially the postgres_fdw module (federate two Postgres databases)?

      PostgreSQL: Documentation: 9.4: postgres_fdw

       

      Opposing to Teiid, I see that FDW requires you to provide the metadata for the foreign objects. Also the supported functionality might be different from one Wrapper to another. Remote query optimization is also unclear. From postgres_fdw doc: "To reduce the risk of misexecution of queries, WHERE clauses are not sent to the remote server unless they use only built-in data types, operators, and functions. Operators and functions in the clauses must be IMMUTABLE as well."

       

      Thanks,

      Andriy