| From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
|---|---|
| To: | "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>, "Steve(dot)Toutant(at)inspq(dot)qc(dot)ca" <Steve(dot)Toutant(at)inspq(dot)qc(dot)ca> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: exceeded MAX_ALLOCATED_DESCS while trying to open file |
| Date: | 2013-05-28 15:56:37 |
| Message-ID: | A76B25F2823E954C9E45E32FA49D70EC1B7E4722@mail.corp.perceptron.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve.Toutant | 2013-05-28 16:06:00 | Re: exceeded MAX_ALLOCATED_DESCS while trying to open file |
| Previous Message | ktm@rice.edu | 2013-05-28 15:48:37 | Re: exceeded MAX_ALLOCATED_DESCS while trying to open file |