3 ms·
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
by bbromhead 14y ago
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
- Detrus 14y agoAt a glance it seems the wrapper complicates things if you need performance and when using Redis performance is often the point.
- bbromhead 14y agoIt 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).