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

    Teiid vs Foreign Data Wrappers in Postgres

    Andriy Rokhmanov Newbie



      Has anybody compared the Teiid and FDW functionality from Postgres?


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