| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>, Steve(dot)Toutant(at)inspq(dot)qc(dot)ca, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: exceeded MAX_ALLOCATED_DESCS while trying to open file |
| Date: | 2013-06-01 05:07:34 |
| Message-ID: | 15375.1370063254@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> ktm(at)rice(dot)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.
Yeah, we need to fix file_fdw so that it's using virtual rather than
physical file descriptors ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | prakhar jauhari | 2013-06-03 12:43:32 | Re: Steps to switch from Master to standby mode : |
| Previous Message | Josh Tanski | 2013-05-31 17:50:23 | Re: 8.4 to 9.1 Upgrade Kerberos Auth Stops Working "Wrong principal in request" |