Teiid vs Foreign Data Wrappers in Postgres

rokhmanov Jun 30, 2015 6:38 PM

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

1. Re: Teiid vs Foreign Data Wrappers in Postgres

rareddy Jul 1, 2015 4:01 PM (in response to rokhmanov)

Andrily,

Yes, we have. Postgres is implementing the SQL-MED specification, which Teiid tries to follow whereever it is possible in terms of syntax. You are right the push down type enhancements not defined in the spec, but I believe it is up to the individual project to come up those. I am not sure about performance, Steve knows lot more about it.

Ramesh..
Actions