Re: memory usage of group by select

From: Anthony <osm(at)inbox(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: memory usage of group by select
Date: 2009-12-29 20:43:12
Message-ID: 71cd4dd90912291243k5e7e80b1lb83770eb69590417@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 29, 2009 at 3:41 PM, Anthony <osm(at)inbox(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-12-29 20:44:59 Re: DDL commands take forever
Previous Message Tom Lane 2009-12-29 20:43:06 Re: Planner Row Estimate with Function