> > Hi Steve, > > 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? > > Regards, > Ken > Hi Ken, So, it means that number of (different) foreign tables joined in single select cannot exceed 10, right? Regards, Igor Neyman -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
