2014/1/24 Emmanuel Medernach <medernac@xxxxxxxxxxxxxxxxx>: > Hello, > > I'm currently testing postgres_fdw feature on PostgreSQL 9.3.2 and I have > some questions: > > - What are the limits to the number of foreign tables ? As far as I know, there is no limit (beyond the usual PostgreSQL limits). > - What is the current status about foreign joins push-down ? Unless I'm mistaken (and no doubt someone will correct me if I am), joins cannot be pushed down yet, only WHERE clauses for individual foreign table rows. To quote this article about PostgreSQL 9.3: http://lwn.net/Articles/550418/ 'More work needs to be done in this area to make this a full "big data" solution, however; Hanada hopes to add "push down" of joins, sorts, and aggregates in future versions of PostgreSQL." See also this thread: http://www.postgresql.org/message-id/20131121150515.GC23976@xxxxxxxxxx Regards Ian Barwick -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
