News for hackers. Stuff that matters.
Re:Redis in my Postgres by bbromhead on Thursday October 18, 2012 @09:00PM (#4671813)
Some of the postgres fdws dont pass conditions to the foreign data source because the mapping is sometimes "too hard". So the fdw will do something like select * from table, stream the results and postgres will do the rest of the heavy lifting for you.

Though for the fdws that talk to other SQL based databases, they will pass most of the conditions on to the foreign data source as it is "usually" all just sql.

So the answer is... it depends! :P

edited: I forgot how to write sentences good and stuff

Re:Redis in my Postgres by Detrus on Thursday October 18, 2012 @10:20PM (#4672016)
At a glance it seems the wrapper complicates things if you need performance and when using Redis performance is often the point.
Re:Redis in my Postgres by bbromhead on Thursday October 18, 2012 @11:56PM (#4672204)
It can certainly do that, though for most cases we have found that network throughput and disk I/O will get in the way first (for other FDWs.. we have never used the Redis one).