ktm@rice.edu wrote:
> Each SELECT opens your FOREIGN TABLE so you are opening it 10 times. This is
> hardcoded by a #define in ./src/backend/storage/file/fd.c during the build so
> you would need to recompile the software yourself to change it. Can you re-
> write your query using a single SELECT or possibly read the data into a
> temporary table for processing?
To me this sounds like a bug in whatever FDW is being used.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
