Re: postgres 8.4.9: running out of memory (malloc fails) when running a transaction that runs a LOT of selects

From: Benedikt Grundmann <bgrundmann(at)janestreet(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: postgres 8.4.9: running out of memory (malloc fails) when running a transaction that runs a LOT of selects
Date: 2012-07-20 10:34:34
Message-ID: CADbMkNOq0S8QiH-5PxuUxO7H-ooYpyQ4ZAV=WcD8Vck3d7-kEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jul 20, 2012 at 10:56 AM, Benedikt Grundmann
<bgrundmann(at)janestreet(dot)com> wrote:
> On Fri, Jul 20, 2012 at 10:46 AM, Benedikt Grundmann
> <bgrundmann(at)janestreet(dot)com> wrote:
>>
> Actually I believe this must be it. I just went back and checked the library
> and it does not CLOSE the cursors. This is normally not a problem as most
> transactions we have run one or two queries only... I'll patch the library
> to CLOSE the cursor when all the data has been delivered and test if the
> error does not happen then.
>
Just to confirm that indeed fixed it. Sorry for the noise.

Bene

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2012-07-20 10:45:55 Re: postgres 8.4.9: running out of memory (malloc fails) when running a transaction that runs a LOT of selects
Previous Message Benedikt Grundmann 2012-07-20 09:56:09 Re: postgres 8.4.9: running out of memory (malloc fails) when running a transaction that runs a LOT of selects