Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UhMqJ-0000Yk-DO for pgsql-admin@arkaria.postgresql.org; Tue, 28 May 2013 16:33:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UhMqI-0004HZ-NE for pgsql-admin@arkaria.postgresql.org; Tue, 28 May 2013 16:33:46 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UhMqH-0004HT-L1 for pgsql-admin@postgresql.org; Tue, 28 May 2013 16:33:45 +0000 Received: from smtprelay0243.b.hostedemail.com ([64.98.42.243] helo=smtprelay.b.hostedemail.com) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UhMq8-0004XI-Gc for pgsql-admin@postgresql.org; Tue, 28 May 2013 16:33:44 +0000 Received: from filter.hostedemail.com (b-bigip1 [10.5.19.254]) by smtprelay04.b.hostedemail.com (Postfix) with ESMTP id A37197B848; Tue, 28 May 2013 16:33:35 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Panda: scanned! X-Spam-Summary: 20, 1.5, 0, , d41d8cd98f00b204, alvherre@alvh.no-ip.org, :::::, RULES_HIT:355:379:599:800:967:973:988:989:1042:1260:1277:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1534:1538:1593:1594:1595:1596:1711:1714:1730:1747:1777:1792:2393:2525:2560:2563:2682:2685:2828:2859:2914:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3350:3865:3867:3870:3871:3872:3873:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4250:4416:4605:4659:5007:6119:6261:7903:8527:9025:9121:10009:10400:10848:11232:11256:11257:11658:11914:12043:12517:12519:13069:13311:13357:13891:13894:13895, 0, RBL:none, CacheIP:none, Bayesian:0.5, 0.5, 0.5, Netcheck:none, DomainCache:0, MSF:not bulk, SPF:fn, MSBL:0, DNSBL:none, Custom_rules:0:1:0 X-HE-Tag: curve06_768c9d432980c X-Filterd-Recvd-Size: 1550 Received: from eldon.alvh.no-ip.org (unknown [186.37.63.107]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf11.b.hostedemail.com (Postfix) with ESMTPA; Tue, 28 May 2013 16:33:34 +0000 (UTC) Received: by eldon.alvh.no-ip.org (Postfix, from userid 1000) id 19EAA1F95; Tue, 28 May 2013 12:33:33 -0400 (CLT) Date: Tue, 28 May 2013 12:33:33 -0400 From: Alvaro Herrera To: "ktm@rice.edu" Cc: Steve.Toutant@inspq.qc.ca, pgsql-admin@postgresql.org Subject: Re: exceeded MAX_ALLOCATED_DESCS while trying to open file Message-ID: <20130528163332.GW15045@eldon.alvh.no-ip.org> References: <20130528154837.GQ12507@aart.rice.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20130528154837.GQ12507@aart.rice.edu> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin