Re: memory usage of group by select - Mailing list pgsql-general

From Anthony
Subject Re: memory usage of group by select
Date
Msg-id 71cd4dd90912291243k5e7e80b1lb83770eb69590417@mail.gmail.com
Whole thread Raw
In response to memory usage of group by select  (Anthony <osm@inbox.org>)
Responses Re: memory usage of group by select  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
On Tue, Dec 29, 2009 at 3:41 PM, Anthony <osm@inbox.org> wrote:
I'm running a group by query on a table with over a billion rows and my memory usage is seemingly growing without bounds.  Eventually the mem usage exceeds my physical memory and everything starts swapping.

I guess I didn't ask my question.  Is this expected behavior?  Is there any way for me to adjust my settings to avoid using so much memory?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Planner Row Estimate with Function
Next
From: Merlin Moncure
Date:
Subject: Re: DDL commands take forever