Re: exceeded MAX_ALLOCATED_DESCS while trying to open file - Mailing list pgsql-admin

>
> 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