Re: exceeded MAX_ALLOCATED_DESCS while trying to open file

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
Cc: 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-05-28 16:33:33
Message-ID: 20130528163332.GW15045@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2013-05-28 22:03:41 Re: WAL files required to make base backup consistent
Previous Message Steve.Toutant 2013-05-28 16:06:00 Re: exceeded MAX_ALLOCATED_DESCS while trying to open file