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

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Benedikt Grundmann <bgrundmann(at)janestreet(dot)com>
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:45:55
Message-ID: 201207201245.55208.andres@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Friday, July 20, 2012 11:56:09 AM Benedikt Grundmann wrote:
> I also noticed just know that all TopMemoryContext's after the first one
> look significantly different. They contain large PortalMemory sections.
> Are those related to cursors?
Yes.

Andres
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2012-07-20 11:48:21 Re: SP-GiST for ranges based on 2d-mapping and quad-tree
Previous Message Benedikt Grundmann 2012-07-20 10:34:34 Re: postgres 8.4.9: running out of memory (malloc fails) when running a transaction that runs a LOT of selects